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

9 votes106 views3 answers
Mysql run sql file
SQL
0 vote105 views1 answer
Create table using the clause with as
SQL
3 votes99 views1 answer
Oracle list user grants
SQL
79 votes268 views6 answers
Grepper code
SQL
0 vote103 views1 answer
Oracle merge insert if not exists
SQL
0 vote102 views1 answer
Oracle exchange subpartition
SQL
0 vote125 views1 answer
The fetch keyword oracle
SQL
0 vote261 views1 answer
Current month transactions in mysql
SQL
9 votes94 views2 answers
Get first 3 letters in sql
SQL
15 votes99 views2 answers
Install mysql 8 ubuntu 18.04
SQL