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 vote113 views2 answers
Find lowest number in sql
SQL
37 votes202 views3 answers
Sql check duplicate value in column
SQL
0 vote110 views1 answer
Enable full text search mysql
SQL
0 vote114 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote74 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
1 vote119 views1 answer
Oracle apex version view
SQL
0 vote147 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote126 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote95 views1 answer
Clone table structure mysql
SQL
-1 vote110 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL