use tempdb; go create table dbo.t ( i int not null ); go create trigger ins_t on dbo.t after insert as begin return; end; go create trigger DdlTrigg on database after alter_table as begin declare @e xml = eventdata(); select n.t.value('Name[1]', 'nvarchar(260)') as disabled_trigger from @e.nodes('/EVENT_INSTANCE/AlterTableActionList/Disable/Triggers[1]') as n(t) select n.t.value('Name[1]', 'nvarchar(260)') as enabled_trigger from @e.nodes('/EVENT_INSTANCE/AlterTableActionList/Enable/Triggers[1]') as n(t) return; end; go -- Try disabling trigger on some tables: alter table dbo.t disable trigger ins_t; alter table dbo.t enable trigger ins_t; go drop table dbo.t; drop trigger DdlTrigg on database; go
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)