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

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

 

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

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

 

别的操作以此类推。

 

select'exec sp_helptext ['+object_name(id) +']
print ''go''
'from syscomments where id in (selectobject_idfrom sys.objects where type ='P')