查询某个表被哪些存储过程（以下简称 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%' 注意：(select object_id from sys.objects where type ='P') and text like'%表名%' 查询存储过程，文本中包含‘表名’ 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%' 注意：(select object_id from sys.objects where type ='P') and text like'%update tablename%' 查询存储过程，文本中包含 ‘update 表名’。同理可以查询 ‘insert into LSEquipment’，‘into 表名’