查找触发器

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