查出MSQLserver的触发器

Select name as 触发器名称,object_name(parent_obj) as 所在表名
from sysobjects where xtype= 'TR ' order by Crdate desc

 

另一种方法

 

SELECT * FROM sys.triggers