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 vote165 views2 answers
Procedure syntax
SQL
3 votes200 views1 answer
Oracle function
SQL
0 vote159 views1 answer
How to select a row in sql
SQL
0 vote154 views1 answer
Database get 10 user aleatory
SQL
0 vote267 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote144 views1 answer
Replace multiple string in query sql
SQL
0 vote147 views1 answer
Oracle job class
SQL
1 vote145 views1 answer
Get table column names sql ssms
SQL
0 vote151 views1 answer
Criteria builder select subset of column
SQL
2 votes158 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL