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

31 votes308 views3 answers
Sql count
SQL
0 vote364 views1 answer
How to locate pg_hba.conf file
SQL
14 votes331 views4 answers
Online sql compiler
SQL
0 vote301 views1 answer
Dump only schema
SQL
3 votes325 views1 answer
Fk in insert mysql
SQL
-1 vote322 views3 answers
Mysql get age from date
SQL
0 vote318 views1 answer
How to create an SQL save method in ruby
SQL
13 votes307 views4 answers
Mysql get last row
SQL
0 vote317 views1 answer
Pl sql constraint user function
SQL
2 votes337 views1 answer
Oracle sql merge
SQL