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 vote173 views1 answer
Pl sql create table from another table
SQL
0 vote179 views1 answer
Sql delete dastabase
SQL
2 votes154 views1 answer
Mysql list users on ubuntu
SQL
0 vote167 views2 answers
Nosqlbooster query other collection
SQL
8 votes163 views2 answers
Mysql get first x characters
SQL
8 votes168 views1 answer
Oracle add auto_increment column to existing table
SQL
2 votes169 views1 answer
How to check if a row is null in sql
SQL
0 vote256 views1 answer
Install ms sql server management studio
SQL
0 vote184 views1 answer
Hallo
SQL
0 vote188 views2 answers
Collation in sql
SQL