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 |
|
Beaulieu
Starting Member
1 Post |
 Posted - 2004-05-19 : 13:02:05
|
| Is it possible that i can use a store proc to modify all the rest of my store procedures that i have in my DB ??I have so many created allready and it will be to long to go throught each one of them to modify my text inside.what i wish to do is a store proc that will allow me to loop to all my store proc of the current DB and look inside for specific text that i would like to change with the new value !!any advise or example..thanx. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-19 : 13:09:35
|
| Just script out all stored procedures to one text file. Make sure to include drop and create statements. Then do a replace on your text. Then execute the modified file in Query Analyzer. You can easily script out objects using Enterprise Manager's generate SQL script wizard.Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Modify all store proc in DB in one shot
A couple of ideas here...