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 vote293 views1 answer
Mysql Like(searching in the string)
SQL
0 vote288 views2 answers
Mysql updating multiple column values from array variable
SQL
3 votes332 views1 answer
Where id is in list sql
SQL
31 votes294 views4 answers
How to get duplicate records with multiple field in sql
SQL
2 votes280 views1 answer
Sql ignore accents
SQL
5 votes288 views3 answers
String concatenation sql server
SQL
2 votes319 views5 answers
Install postgresql 10 centos 7
SQL
2 votes331 views1 answer
Oracle find constraints referencing a table
SQL
1 vote285 views1 answer
Can not connect to mysql server
SQL
1 vote291 views1 answer
How to make a select in sql
SQL