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

select distinct object_name(id) from syscomments
where id in (select object_id from sys.objects where type ='P')
and text like '%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')