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

6 votes265 views2 answers
Mysql first day of month
SQL
0 vote275 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote276 views1 answer
Last date for each user sql
SQL
0 vote286 views1 answer
Apache Derby: Create SQL Dump with data
SQL
4 votes276 views3 answers
Check if two date ranges overlap sql server
SQL
3 votes262 views2 answers
Mysql HAVING
SQL
0 vote294 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote285 views1 answer
Postgres grep entire database
SQL
0 vote279 views1 answer
Update having mysql
SQL
0 vote264 views1 answer
Sql transact create cursor with dynamic tables
SQL