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

2 votes105 views1 answer
Can you use a where clause for a child query
SQL
1 vote187 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote120 views1 answer
Initcap in mysql
SQL
12 votes109 views4 answers
SQL Where
SQL
-1 vote154 views1 answer
Brisanje dupliranih konatakata
SQL
6 votes126 views1 answer
Oracle rank
SQL
1 vote109 views1 answer
Drush sql-dump
SQL
0 vote132 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote115 views1 answer
Optimize sql query
SQL
1 vote113 views1 answer
Mysql view command
SQL