Mega Code Archive

 

Categories / MSSQL Tutorial / Trigger

 

CREATE TRIGGER prevent_drop_triggers ON DATABASE FOR DROP_TRIGGER

CREATE TRIGGER prevent_drop_triggers        ON DATABASE FOR DROP_TRIGGER        AS PRINT 'You must disable "prevent_drop_triggers" to drop any trigger'        ROLLBACK