September 23, 2003 at 2:09 pm
Is the a way to do a search and replace for all or a group of stored procedures? I.E. I need to change a variable name that is in 20 store procedures without having to pull each one up and edit it.
September 23, 2003 at 2:18 pm
September 24, 2003 at 2:09 pm
I wrote a script a while back that would read the syscomments table and look for a specific piece of text for a given type of object. It would then create a script that would allow you to recreate the object with the replaced text. I'll see if I'm allowed to post that here or not. It's a very useful piece of SQL.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply