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).

Please complete the following information:

REGISTER / LOG-IN TO DISCUSS

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Submit your e-mail address below to continue

E-mail: 

E-mail: 

Handle:   

Password: 

Forgot Password?

Create Handle: 

Your handle identifies you in ITKnowledgeExchange. Max 30 char.

Create Password: 

Confirm Password: 

Yes, I agree to the IT Knowledge Exchange  Terms and Conditions.

hidden modal window