Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2005-06-13 : 04:35:54
|
| What permissions are required to TRUNCATE a table? I am getting the following error when i try to truncate..where as i am able to delete from the table.....----------------------------------------------------------------User does not have permission to perform this operation on table 'rl_test'.----------------------------------------------------------------------------------------I think, therefore I am - Rene Descartes |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2005-06-13 : 04:46:57
|
| You need to be one of these:table owner sysadmin db_owner db_ddladminMark |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-06-13 : 04:49:51
|
| Thank you..------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
TRUNCATE TABLE