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

'

)