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 vote338 views2 answers
Postgresql change user role grant
SQL
0 vote322 views1 answer
Add SuperUser MySQL
SQL
0 vote348 views1 answer
Sqlite insert or update
SQL
0 vote323 views1 answer
Install postgresql 12 on debian 10
SQL
23 votes334 views1 answer
How remove column in mysql
SQL
0 vote327 views1 answer
Mysql disable query caching
SQL
2 votes316 views1 answer
Mysql add boolean column
SQL
0 vote344 views1 answer
Clear query cache sql server
SQL
1 vote349 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
1 vote328 views1 answer
Show structure of table in sql
SQL