Copying Stored Procedures

I have and ASP.NET and VB.NET application that needs to copy selected stored procedures from one SQL Server to another SQL Server. The scenerio is that the user will select a source server from a drop down list then the source database from another dropdown listbox which then populates a listbox with the stored procedures in the database. They can select multiple stored procedures from the listbox.

Once selected, they select a target SQL Server from a dropdownlist and then a target database from another dropwdown list. I have a command button that they need to do the actual move but I am not sure how to get the selected source stored procedures copied to the target database. Any ideas would be greatly appreciated.

You might be able to program a DTS job to get this done.

How can I use DTS to copy them to the target server during runtime?

you can make a DTS package (using sql server)which can be run easly by vb.net/vb/asp/asp.net.

if u waitto know how to create package. let me know

dipit