Very interesting. As to the original question, how is EM registered?

Steve Jones

steve@dkranch.net

What is in your package? If you use the copy SQL objects task, then you have a checkbox for dependencies and include indexes and keys.

Steve Jones

steve@dkranch.net

It would be interesting to see if this works with a Unix based server. trying to find one now.

Steve Jones

steve@dkranch.net

That's a good solution that solves part of the problem. Personally, I think this is an area that SQL Server 2002 could greatly improve, but we shall see.

Steve Jones

steve@dkranch.net

Keep in mind that if you are importing data v objects, there are different needs. Your DTS package can be set to create the objects (and dependencies) and then move...

Interesting. Does this work in all windows versions, or is it a 2000 thing. I wasn't aware NET USE could run through FTP, especially in Pre-W2K systems.

Steve Jones

steve@dkranch.net

That's a good idea, but I tend to agree with Andy. I constantly run into places where DTS falls short and I have to accept a less than bulletproof solution...

And that one time is when the restore will be needed!!! Stick with disk (Seems to be the consensus).

Steve Jones

steve@dkranch.net

I agree with Brian's points, but I still use Crucial memory.

However, a recent development in the last week of 2001. A friend was testing some high end clients with fully...

It appears in SQL like a "Print" message. You could try seeing if you can get print statements back.

It is a good question. You could always execute it from a...

Are you sure these are well tuned queries?

Check that first.

I think they will be costly because I am not sure the parser will efficiently match these up. One thing I...

I agree with Andy. Nothing really tricky. Not sure if other RDBMSs support INSTEAD OF Trigers or some other new features in SQL 2000, but outside of the new features,...

dtsrun is the executable that will run a DTS package. You could execute this from xp_cmdshell to run a DTS package.

Alternatively, you could schedule the DTS package and use...

I tend to agree with Andy. VB is a great place to learn a new skill. XML is good if you have a need, but it's still a lesser used...

, Actually I was 80% done when I took the beta. Had to be sure I covered everything. Took the live test to be sure that nothing...