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

5 votes259 views2 answers
Mysql date greater than 30 days
SQL
0 vote274 views1 answer
Mysql row generator
SQL
0 vote256 views1 answer
Sql describe
SQL
0 vote280 views1 answer
Is not numeric sql
SQL
0 vote269 views1 answer
Mysql drop trigger
SQL
0 vote277 views1 answer
Close sql query vb.net
SQL
2 votes276 views1 answer
Postgresql change value in column
SQL
0 vote257 views1 answer
Sql create table with references not primary key
SQL
0 vote293 views1 answer
Mariadb change column type
SQL
4 votes287 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL