Change Multiple Stored Procedure with Query Statement 1

[CrystalJack]

I'm moving several tables and stored procedures to anther server.

Server one is named Genesis and the database is Genesis.
Server two is named Genesis and the database will be named MonthHistory.

Problem:

The tables names don't use full path address.
(example:
ClaimStat -instead of- Genesis.Genesis.dbo.ClaimStat)

Is there a query statement that I can write to update the table in the stored procedures so I don't have to do it manually?

 

[vadimg]

in general, updating system tables (syscomments in this case), is not recommended!
I think the best thing to do here is script out a DROP/CREATE text file of all procs, and 'find/replace' object names in the file.