Yes, that's the stuff. Thanks for that.

You couldn't recommend a good beginners guide for xquery could you?

Thanks,

Rob

Suman,

I found the following on the internet:

Everybody,

Thanks for the suggestions, but as I mentioned, you aren't going to fix this (not unless you pay a visit to my workplace).  It isn't the bulk copy syntax or a...

Kenneth,

I'm running this locally, so I'm not using a computer name or an IP address.

Rob

How do I close this as an issue?  I think this problem is caused by the local installation of SQL Server.  I'd noticed a while back that Query Analyser and...

I can answer that last question myself.  It's definitely slow.  Equivalent jobs on different servers take 1 second to run, however the bulk copy is also very fast from command line on...

Joe...you read me correctly.

The select statements take (at most) of a couple of seconds through query analyser.  The jobs are being run on the local server so I doubt the...

I think that must be it.  It takes exactly that long to run from command line aswell.  I think I'm stuck with the problem.

Thanks for answering.