Hi,
I am using the SQL server 2000, trying to import and/or export stored procedures from remote server to my computer and vise versa. all I can do is to import/export tables and I am not sure how to correct the set up to transfer stored procs as well. Any idea?

Thanks

You can do this from a DTS Package using the task "Copy SQL Server Objects". On the Copy tab, uncheck "Copy all Objects" then click the "Select Objects" button to choose the stored procs and tables you want.

Or you can generate SQL scripts from the source database and run the scripts against the destination database using Query Analyzer

Hi,
Thanks for the information, I did it but I got a message:
Failed to copy objects from SQL server to SQL server....error occurred.

and no more details.
Does it have anything to do with security set up?

Sometimes there are problems because by default it tries to copy users/logins too. You can change these default options to just copy the objects and try again. Also you can turn on logging in the DTS - See BOL.

Or try the SQL scripts approach, that's what I use - I find them much easier to debug than a DTS.

Thank you very much.

I unchecked all selections under 'default options', I unchecked include all dependent objects under 'Create destination object...', then I got the faild message!... although it did transfer the stored procs this time!...(I wish I knew what is going on)