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 vote176 views1 answer
Less than and between in sql query
SQL
0 vote147 views1 answer
Sql table to store status
SQL
0 vote193 views1 answer
Create table split string function in sql server
SQL
0 vote187 views1 answer
Kotlin sqlite delete row
SQL
3 votes223 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
4 votes187 views1 answer
Search column by name mysql
SQL
0 vote163 views1 answer
Postgresql newline character
SQL
2 votes200 views3 answers
Sql function
SQL
6 votes267 views1 answer
Check Table Exists
SQL
1 vote236 views1 answer
Oracle select first row order by
SQL