sql2008 查询某个表被那些存储过程用到

selectdistinctobject_name(id) from syscomments where id in (selectobject_idfrom sys.objects where type ='P') andtextlike'%tablename%'

复制代码

 

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

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 ' exec sp_helptext [ ' + object_name (id) + ' ]
print '' go ''
' from syscomments where id in ( select object_id from sys.objects where type = ' P ' )

复制代码

转载于:https://www.cnblogs.com/Ruiky/archive/2012/03/26/2418216.html