SQLServer 查询数据库中所有的触发器，查询某张表哪些存储过程用到了

1、SQLServer 查询数据库中所有的触发器

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' and c.text like '%bom_weight_wkx%'
ORDER BY [表名]
 

2、查询某张表哪些存储过程用到了

SELECT DISTINCT  b.name,  b.type  FROM dbo.syscomments a,  dbo.sysobjects b WHERE a.id = b.id AND b.xtype = 'p'  AND a.text LIKE '%表名%'