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

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

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

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

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