学步园

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')