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

2 votes358 views3 answers
Row number mssql
SQL
9 votes351 views5 answers
Laravel to sql
SQL
11 votes341 views1 answer
Mysql order by two columns priority
SQL
5 votes335 views2 answers
Add column postgres with default value
SQL
0 vote327 views1 answer
Mysql installer no packages found
SQL
13 votes347 views2 answers
Sql online compiler
SQL
0 vote345 views1 answer
Java sql connection
SQL
0 vote330 views1 answer
Sqlite update where exists
SQL
65 votes561 views6 answers
Sql add column to table
SQL
0 vote343 views1 answer
Mysql query to add hours to column in table
SQL