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 vote222 views1 answer
Sqlalchemy orm duplicate
SQL
1 vote274 views1 answer
Mysql is odd
SQL
2 votes175 views3 answers
Current month mysql query
SQL
2 votes124 views1 answer
Sql view column data type
SQL
0 vote212 views1 answer
How to find date from date table in sql
SQL
0 vote184 views1 answer
Order by with where clause in mysql
SQL
0 vote165 views1 answer
Inser into example
SQL
19 votes187 views6 answers
Sql drop table if exists
SQL
0 vote181 views1 answer
Test the postgresql db connection
SQL
1 vote186 views2 answers
Mysql update table from another table
SQL