Changing table name in stored procedures

[TheWebDataGuy]

Is there a way to programmatically change a table name in all the stored procedures without having to change it one-by-one?

We have a few dozen stored procedures and would like to change reference to particular table. Say table1 to be changed to table2 everywhere.

Any ideas?

Thanks,

 

[jby1]

Aside from opening the procedure in Query Analyzer, and doing a 'Find and Replace' operation, can't think of anything!

 

[ks2000]

You just run SP_DEPENDS before modifying any schema on the database. By that you can get a list of stored procedures which depends on that table.



Good Luck
Gopala Krishna Kakani