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