随笔分类 -  SqlServer2000

启动或停止所有触发器
摘要:启动: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 ... 阅读全文
posted @ 2008-04-22 14:56 沉在海底的船 阅读(755) 评论(0) 推荐(0)