select distinct object_name(id) from syscomments where id in
(select id from sysobjects where type =‘P‘) and text like‘%TableName%‘
2.查找那些过程对该表做了更新操作：
select distinct object_name(id) from syscomments where id in
(select id from sysobjects where type =‘P‘) and text like‘%update tablename%‘
SQL server 查询某个表在哪些存储过程（SP）中使用到
原文：http://www.cnblogs.com/yzl495/p/4118750.html