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.
| Author |
Topic |
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
 Posted - 2008-01-11 : 21:26:36
|
| Good day to all...I have 213 stored procedures in a single database. What I want to do is to replace a specific word in all 213 stored procedures at once. Can this be possible?Thanks in advance.For fast result follow this...http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxWant Philippines to become 1st World COuntry? Go for World War 3... |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-01-12 : 01:12:54
|
script out all the procs to files, then do search and replace with your favorite code editor.but really you should have all your procs in source control so there's no need to script them out, right? 
elsasoft.org |
 |
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
|
|
|
|
|
Replace all stored proc content at once.
hehehe... thanks. 
For fast result follow this...