Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS strangeness

Author  Topic 

hyefive
Starting Member

16 Posts

Posted - 2005-03-31 : 22:20:34
Hi,

Can someone explain this most unusual occurrence to me:

I'm using DTS to Import my stored procedures from one MSSQL Server 7.0 to another.

After unchecking the 'Copy All Objects' box, I then click 'Select Objects...' and remove checks from all but 'Show Stored Procedures' box, select all, then check all.

Upon successful transfer, I'll refresh the sp's in EM, and VOILA! there appears a handful of sp objects that were not listed in the Select Objects dialogue box!

What the heck is that!!

TIA to anyone who can explain this,
hyefive
   

- Advertisement -