August 22, 2008 at 12:05 pm
Just want to prevent a table from being truncated.
Have a delete trigger but not sure how to prevent the truncate - thanks.
August 22, 2008 at 12:21 pm
Did you check DDL triggers?
They might help you doing what you want.
August 22, 2008 at 1:05 pm
I did find a posting indicating DDL trigger would work but I can't find the DDL event to use. Unless it falls under a different name. I tried Truncate_Table and just Truncate but both were not valid events. I found this list of events
http://technet.microsoft.com/en-us/library/bb522542.aspx
but no help. I feel like this should be simple but I'm coming up blank. - thanks
August 22, 2008 at 2:34 pm
Don't give people ddl_admin or db_owner rights ... Then you are safe 🙂
* Noel
August 22, 2008 at 2:41 pm
OK
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply