Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Table Update

Author  Topic 

seanworking
Starting Member

13 Posts

Posted - 2008-08-20 : 20:08:34
I need to determine what all stored procedures are updating a database table via a Insert statement. Would anyone tell me the best way to find this information out?

Thanks

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2008-08-20 : 20:22:35
do a like search on syscomments for '%insert%'

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

seanworking
Starting Member

13 Posts

Posted - 2008-08-20 : 20:27:48
Sweet answer dinakar! Thanks a bunch.
Go to Top of Page
   

- Advertisement -