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