How to generate multiple Alter Scripts in SSMS

Posted by dannyRods on Stack Overflow See other posts from Stack Overflow or by dannyRods
Published on 2013-03-05T03:22:10Z Indexed on 2014/06/06 9:25 UTC
Read the original article Hit count: 312


I'm using sql server management studio 2008 to try and generate an alter script for each of my stored procedures in order to save the scripts for each revision. I can easily generate an alter script for each individual procedure, but I'm not trying to go through a hundred stored procedures manually.

I know that SSMS has an automated generate scripts function under task, but the only options are create, drop and create, and drop. I cant seem to figure out how to enable alter. I've already searched through many SO articles, as well as a little digging in msdn, and I've come up with nothing.

I'm hoping that the fine people of stackoverflow will be up to the challenge. Thanks in advance

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server