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 vote194 views1 answer
Alter table change default
SQL
0 vote176 views1 answer
How to find top 3 salary in sql
SQL
53 votes321 views6 answers
How to install mysql ubuntu
SQL
1 vote183 views1 answer
Mysql query bulk insert
SQL
0 vote194 views1 answer
Calculate age in sql
SQL
32 votes199 views6 answers
Insert select
SQL
3 votes174 views1 answer
Sql cast to integer
SQL
0 vote174 views1 answer
Oracle list subpartitions
SQL
0 vote188 views1 answer
Oracle sql log to console
SQL
5 votes180 views3 answers
Truncate function in sql oracle
SQL