启动或停止所有触发器

启动：
declare   @s   varchar(8000) 
set   @s   =   '' 
select   @s=@s+' alter table '+t.name +' Enable trigger '+tr.name from
(select parent_obj,name from sysobjects where xtype='TR')
tr 
left join
(
select Id,name from sysobjects where xtype='U' 
)t
on t.id=tr.parent_obj
exec(@s)
停止
declare   @s   varchar(8000) 
set   @s   =   '' 
select   @s=@s+' alter table '+t.name +' Disable trigger '+tr.name from
(select parent_obj,name from sysobjects where xtype='TR')
tr 
left join
(
select Id,name from sysobjects where xtype='U' 
)t
on t.id=tr.parent_obj
exec(@s)

转载于:https://www.cnblogs.com/zhpeng/archive/2008/04/22/1165630.html