SQL Server 2000也可以
ALTER TABLE XX DISABLE TRIGGER ALL
ALTER TABLE XX ENABLE TRIGGER ALL
最近發現有個Table的Trigger被Disable了,怕還是其他Table也被這樣誤操作,但是Table太多,所以想問下有沒辦法一次查出.
select * from sysobjects where type='TR' and status=1610615808(disable)
select * from sysobjects where type='TR' and status=1610613760(enable)
测了下,这个字段表征是否enable
select a.name 'Trigger Name',b.name 'Tab Name'from sysobjects a,sysobjects b
where a.type='TR' and a.status=1610615808 and a.parent_obj=b.id
所有被disbale的trigger及所在表