SQL 查询某个表在哪些存储过程（SP）中被使用到

1.查询某个表被哪些存储过程(以下简称 SP)使用 :

select distinct object_name(id) from syscomments where id in

(select object_id from sys.objects where type='P') and text like'%TableName%'

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

select distinct object_name(id) from syscomments where id in

(select object_id from sys.objects where type='P') and text like'%update tablename%'

3.查询当前数据库中所有SP：

select name as 存储过程 from sysobjects where type = 'P'