mssql查看数据库中所有触发器语句

SELECT  

     object_name(a.parent_obj) as [表名] 

     ,a. name as [触发器名称] 

     ,( case when b.is_disabled=0 then '启用' else '禁用' end ) as [状态] 

     ,b.create_date as [创建日期] 

     ,b.modify_date as [修改日期] 

     ,c.text as [触发器语句] 

FROM sysobjects a 

     INNER JOIN sys.triggers b 

         ON b.object_id=a.id 

     INNER JOIN syscomments c 

         ON c.id=a.id 

WHERE a.xtype= 'tr' 

ORDER BY [表名]