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

  • July 20, 2016 at 2:11 pm

    #1891156

    No more tears.

    ALTER SERVER ROLE [sysadmin] DROP MEMBER [<USER_NAME>];

    USE <DB_NAME>;

    ALTER ROLE [db_owner] DROP MEMBER [<USER_NAME>];

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho