Home Forums SQL Server 2014 Administration - SQL Server 2014 How to prevent a table from being truncated or dropped RE: How to prevent a table from being truncated or dropped
j-1064772
SSCertifiable
Points: 5316
More actions
August 25, 2016 at 1:58 pm
#1897645
Eric M Russell (7/20/2016)No more tears.ALTER SERVER ROLE [sysadmin] DROP MEMBER [<USER_NAME>];USE <DB_NAME>;ALTER ROLE [db_owner] DROP MEMBER [<USER_NAME>];
Eric M Russell (7/20/2016)
ALTER SERVER ROLE [sysadmin] DROP MEMBER [<USER_NAME>];
USE <DB_NAME>;
ALTER ROLE [db_owner] DROP MEMBER [<USER_NAME>];
Too funny. I'm surprised nobody else picked up on this one.