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

3 votes214 views1 answer
Select database in sql
SQL
0 vote277 views1 answer
Generate random & unique mysql string
SQL
0 vote235 views1 answer
Sql server delete records with specific date
SQL
3 votes202 views1 answer
Select nextval from sequence sql
SQL
2 votes213 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote200 views1 answer
Sql row number in result set
SQL
0 vote204 views2 answers
Generate sql trigger through ef migration
SQL
0 vote212 views1 answer
Kill thread
SQL
0 vote192 views1 answer
Restore backup "text" postgresql command line
SQL
6 votes203 views1 answer
Oracle desc table primary key
SQL