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 vote208 views2 answers
Mysql does sentance contain word
SQL
1 vote219 views1 answer
Login to database mysql terminal
SQL
0 vote206 views1 answer
Show table structure mysql console
SQL
5 votes203 views1 answer
Oracle list packages
SQL
0 vote227 views1 answer
Select odd records sql
SQL
5 votes233 views1 answer
Mysql add user with all privileges
SQL
0 vote230 views1 answer
Convert LDAP Epoch to Date
SQL
4 votes217 views1 answer
Change nls_date_format
SQL
0 vote169 views1 answer
How to get last client id sql
SQL
0 vote200 views1 answer
Mysql events not work
SQL