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

6 votes223 views2 answers
Join vs union
SQL
0 vote236 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
2 votes253 views2 answers
Create empty table from existing table
SQL
28 votes183 views6 answers
Distinct sql
SQL
2 votes234 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote249 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote178 views1 answer
Import sql file in mysql linux
SQL
2 votes275 views1 answer
Python sql
SQL
0 vote171 views1 answer
Oracle sql replace string in clob
SQL
0 vote215 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL