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 vote201 views1 answer
Mysql take number in string
SQL
2 votes184 views1 answer
Oracle cpu per session
SQL
1 vote202 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote261 views1 answer
Month mysql
SQL
2 votes226 views1 answer
Oracle kill session by sql_id
SQL
5 votes292 views1 answer
Oracle source query
SQL
0 vote201 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote189 views1 answer
Postgres enumerated type
SQL
0 vote184 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
10 votes197 views4 answers
SELECT FROM WHERE
SQL