RATE THIS ANSWER
0
Click to Vote:
0
0
Last Answered:
Apr 4 2008 6:34 PM GMT
by Mrdenny
Latest Contributors: WillC
I recommend that you use Management Studio for SQL 2005 and drill to the database you want the stored procedures from and right click the database name. From the Task menu option select generate scripts to launch the wizard.
Click next. Make sure the database you want is selected and click next and next again.
You should be on the Choose Object Types page and here just select Stored Procedures. After clicking next you are on the Choose Stored Procedures page and now you can select the procedures that you want. Click Finish to begin the process and when it finishes you will have a new query windows with a create script that you can save.
You can also navigate to the Database > Programming > Storage Procedures, and in the object explorer details page, select all the procedures right click and select "Script Stored Procedure As" > Create To > New Query Window (or File if you'd like).