Trigger MSSQL Tutorial

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