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

1 vote142 views1 answer
Store select query result in variable sql server
SQL
11 votes101 views1 answer
Reset identity sql server
SQL
0 vote141 views1 answer
Mysql update sum same table
SQL
0 vote153 views1 answer
Update view sql
SQL
0 vote146 views1 answer
How to order result of subquery in select
SQL
2 votes148 views1 answer
Mysql last 7 days including today
SQL
0 vote150 views1 answer
Primary key multiple colums
SQL
2 votes171 views2 answers
Mysql write into table
SQL
18 votes149 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote137 views1 answer
Sql menampilkan data tabel
SQL