CREATE TRIGGER prevent_drop_triggers ON DATABASE FOR DROP_TRIGGER : Trigger on database « Trigger « SQL Server / T-SQL Tutorial






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








22.7.Trigger on database
22.7.1.CREATE TRIGGER prevent_drop_triggers ON DATABASE FOR DROP_TRIGGER
22.7.2.Creating a DDL Trigger that Audits Database-Level Events