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 votes176 views3 answers
Where clause sql
SQL
2 votes163 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
7 votes187 views3 answers
Sql server check if temp table exists
SQL
2 votes190 views1 answer
Sql server: select column values as comma separated string
SQL
11 votes187 views2 answers
Import sql file laravel cmd
SQL
0 vote156 views1 answer
Returning with sqlalchemy
SQL
2 votes147 views1 answer
Oracle kill job by sid
SQL
0 vote157 views1 answer
Python connect microsoft sql server
SQL
1 vote168 views1 answer
Sql server update column based on another table
SQL
0 vote260 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL