Answers for "disable database droping sql"

SQL
0

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
Posted by: Guest on October-18-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language