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

0 vote372 views1 answer
Logtash mysql cofiguration file
SQL
0 vote352 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote374 views1 answer
Get last three characters in mysql column
SQL
-1 vote344 views1 answer
How to open blade file from blade in laravel
SQL
3 votes354 views2 answers
Sql paging query
SQL
0 vote335 views1 answer
Remove from table where
SQL
0 vote383 views1 answer
Mariadb set vertical output format
SQL
4 votes349 views1 answer
Mysql not equal
SQL
1 vote374 views1 answer
Deleting database in sql
SQL
2 votes352 views1 answer
Oracle list grants on package
SQL