Although you've tried command prompt ftp from both servers, try it again on medium and larger files.  A possibility is different static routes on the boxes causing slow ftp'ing in...

You can maybe try the following as the basis for a DTS activex script that run a telnet session.

Sorry about the dodgy "sleep" functionality.  It works on this here XP...

Up to now has the failing node always been the one from which the transfer has been initiated?

What access do you have to the unix box?  Can you check logs...

One cool feature of "deferred name resolution" is that no matter what you do wrong, you can't accidentally turn it off. 

The slight difference of opinion of Kelvin and Hew BG has prompted me to test the date formats to see who's most correct, using:

declare @dt datetime

set dateformat ymd

set @dt =...

Maybe another component of your application logging on with invalid credentials or with a different method (eg. trusted instead of standard, or vice versa)?

Did the captured ClientProcessID provide any help?

The SQL Error Log entries must be caused by something other than your working application.  Run Profiler, looking for Login Failure events and capturing as many columns as possible.  You...

The scenarios obviously weren't tested before posting this QOD.

The disabling of triggers is the only feasible option. 

Unless you are doing the SELECT from another session??

Now that was one wacko question.

Can we get back to writing questions - and answers - in plain english?

cw,

Yes you're right.  but, the "correct answer" was the best of a bad bunch. 

Still, it beats yesterday's, where the "correct" answer was just plain wrong.

You can install 6.5 client utilities on that same server

The "correct" answer is handy to know, and I don't doubt that it is correct, given the detailed explanation.  However, this message also arises if any sysadmin users are using the...

I'd never recommend it for a situation where it was critical that the data returned was accurate.  However, I have recommended it previously for a web site that displayed live...

Tim,

Further to Ken's post, I set up and traced a DTS object transfer similar to yours, and noted the reset of the db options for the target database (which, in...