Hi All,

I'm not able to transfer stored procedures through DTS. I'm transferring from one db to another db on the same SQL Server. It looks like everything fine but the SPs are not getting transferred.
I've SQL 2K with SP3.

Please throw any ideas..
Thanks...

In message <FFD2345D-BC1E-4E83-9225-BDAC7015EE58 (AT) microsoft (DOT) com>, SQLGuy
<johnfull_2000 (AT) yahoo (DOT) com> writes
If I select Copy All objects then it works fine, and if I select
individual objects, including SPs then this works fine as well.

You can check the scripts produced by the task, and they will be in the
"Script file directory" of the client PC. See the bottom of the Copy tab
for this setting.

I cannot see the problem, and for the sake of saying something, check
you have applied SP3 to the client PC if using one to run Enterprise
Manager, not just the server as this is a common mistake.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org