Posted by Jens on 12/23/05 09:31

1. use the DTS Wizard and specify the "Copy Objects and Data between
SQL Server databases and then select the stored procedures you want to
export.

2. Script up a file by (right) clicking on the appropiate database or
the individual procedure and Select "Generate SQL Script"

HTH, Jens Suessmeyer.

[Back to original message]