select
distinct
object_name
(id)
from
syscomments
where id in ( select object_id from sys.objects where type = ' P ' )
and text like ' %tablename% '
where id in ( select object_id from sys.objects where type = ' P ' )
and text like ' %tablename% '
查找那些过程对该表做了更新操作