Disable database droping sql

CREATE OR ALTER TRIGGER TRG_PreventDropProductionDB ON ALL SERVER
FOR DROP_DATABASE
AS
BEGIN
    IF DB_NAME() = 'ProductionDatabase'
        BEGIN
            RAISERROR('You cannot drop the production database.', 16,1);
            ROLLBACK;
        END
END
GO

Source: dba.stackexchange.com

Similar codes

0 vote326 views1 answer
Create table database in psql
SQL
2 votes353 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote292 views1 answer
MySQL FIND_IN_SET()
SQL
5 votes311 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote305 views1 answer
Order by number of character in sql
SQL
28 votes321 views6 answers
Mysql change user password
SQL
0 vote288 views1 answer
Linux upload database to mysql
SQL
0 vote272 views1 answer
How to get last client id sql
SQL
0 vote312 views1 answer
Reset keys in sql
SQL
0 vote309 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL