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

4 votes133 views1 answer
Group by mysql and concatenate string
SQL
0 vote122 views1 answer
Plpgsql if statement
SQL
0 vote136 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
4 votes120 views2 answers
Oracle default date format
SQL
0 vote112 views1 answer
Knex last insert id mysql
SQL
0 vote131 views1 answer
Soql user profile
SQL
0 vote115 views1 answer
Truncate table sql server foreign key
SQL
5 votes114 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
1 vote114 views1 answer
Oracle lock user
SQL
6 votes135 views2 answers
Insert into select mysql
SQL