MSSQL查询某个表在哪些存储过程中使用过

• 查询某个表被哪些存储过程使用到 :
  

  SELECT DISTINCT
          OBJECT_NAME(id)
  FROM    syscomments
  WHERE   EXISTS ( SELECT 1
                   FROM   sys.objects
                   WHERE  type = 'P'
                          AND object_id = id ) 
          AND text LIKE '%TableName%'

• 查找那些过程对该表做了更新操作：

  SELECT DISTINCT
          OBJECT_NAME(id)
  FROM    syscomments
  WHERE   EXISTS ( SELECT 1
                   FROM   sys.objects
                   WHERE  type = 'P'
                          AND object_id = id ) 
          AND text LIKE '%update TableName%'