Search & replace in multiple stored procedures

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

SQL Server 2005 Forums

SQL Server Administration (2005)

Search & replace in multiple stored procedures

Author

Topic

mxridha
Starting Member

1 Post

Posted - 2007-08-31 : 02:34:27

Hi all,

Does anyone know how to do the search and replace in multiple stored procedures using SQL 2005 Management Studio?
Any help will be appreciated.

Thanks!

Kristen
Test

22859 Posts

Posted - 2007-08-31 : 03:26:35

We store all our source code in files (and then into a version-control system), so a simple find & replace with a programmers editor is then all we need for this type of job.

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Version+Control

Kristen

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-31 : 15:16:11

You can search them by querying sys.syscomments then modify one by one.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-09-03 : 16:29:00

generate the script for the procedures with alter instead of create, search and replace and execute

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources