Bulk Scripting Alter Procedures

• J B-262165

  Old Hand

  Points: 332

  More actions

  January 16, 2007 at 7:35 am

  #683472

  The solution I'm using isn't pretty, but it works. Here's what I do:

  Create a script of all the stored procedures as "create to" file or clipboard. Once it's finished, I put the resulting script in a text editor (like notepad). Once there, I do a find and replace to change the "create" statements to "alter". Be carefull not to do a replace all though! If you do, it'll break any temp tables by changing the "create table" into an "alter table".

  Hope this helps.

  James

• jaypak23

  SSC-Addicted

  Points: 447

  More actions

  January 16, 2007 at 9:28 am

  #683524

  Thanks for the reply.

  I ended up doing something along those lines.  I really wish Microsoft didn't take that functionality out of SQL 2005.  Sometimes, I don't understand why the remove certain functionality.  I guess sometimes it makes sense, but if you've had that fucntionality all along, why change it.

  Thanks!