Generate scripts SQL Server 2008

Question

I would like to generate scripts of about 100 Stored Procedures. When I generate script, all the files contains 'CREATE PROCEDURE' statement. How should I get scripts with 'ALTER PROCEDURE' statement?

gbn · Accepted Answer · 2011-01-15 10:52:49Z

2

Find/replace in an editor
Script with a DROP first
Use a 3rd party to generate a differential script instead

answered Jan 15, 2011 at 10:52

gbn

435k84 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

WraithNath · Accepted Answer · 2011-01-15 10:20:59Z

1

If you generate all the scripts to a new query window you could press Ctrl-Shift-H to get the find and replace in files dialog up and do a finf and replace on 'CREATE PROCEDURE' to 'ALTER PROCEDURE'?

answered Jan 15, 2011 at 10:20

WraithNath

18.1k10 gold badges59 silver badges84 bronze badges

Collectives™ on Stack Overflow

Generate scripts SQL Server 2008

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related