Search Stored Procedures

[digitallyskilled]

I backed up a database and restored the files on my laptop so i can have a local copy. the restored version has references via stored procedures to the production databases. is there a quick way i can search for fully qualifyied references in the stored procedure and replace them with the local references.

 

[dbomrrsm]

not sure if there is a better way but I would script the SP's and then use a text editor to do a search and relace then run the amended SP's back into the DB

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[JamesLean]

You can get a list of SPs that contain the db name by querying the system tables:

SELECT OBJECT_NAME(id)
FROM syscomments
WHERE text LIKE '%<db name>%'

You'll then need to go into each one and amend the name.

--James