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.

• Next in forum: Re: Export SPs?
• Prev in forum: Export SPs?
• Thread view: Re: Export SPs?

[Reply to this message]