select
b.name ,a.
text
from
syscomments a,sysobjects b
where object_id (b.name) = a.id and b.xtype in ( ' TR ' )
where object_id (b.name) = a.id and b.xtype in ( ' TR ' )
来得到用户自定义的触发器里面的内容。
希望这点小发现能帮助和我遇到相同问题的人。:)