is there a way to prevent drop or truncate a specific table by admin ,
in sql server .

Question

is there a way to prevent drop or truncate a specific table by admin  in sql server .

PUNEET BISHT · Answer

can admin prevent himself to drop or truncate specific tables  because sometimes a table is accidently truncated or deleted making view is not a good idea. if i make a trigger it is implemented in all tables in db. i just want to implement it in specific tables

Sivaraman Dhamodaran · Answer

Admin can prevent drop and truncate of specific table by normal user. A normal user can not (Unless one more admin) prevent admin doing the same Do you want to trouble your db admin :)

is there a way to prevent drop or truncate a specific table by admin , in sql server .