select * from dbo.sysobjects where deltrig<>0 or instrig<>0 or updtrig<>0
select name, text ,o.xtype
from sysobjects o, syscomments s
where o.id = s.id and o.xtype like '%tr%'
select * from dbo.sysobjects where deltrig<>0 or instrig<>0 or updtrig<>0
select name, text ,o.xtype
from sysobjects o, syscomments s
where o.id = s.id and o.xtype like '%tr%'