Do you have the Sybase bcp also installed on this machine? You may have to use the full path to bcp.exe to make sure you get the right one,...

Posting the table definitions, sample data and expected results will help get you a tested answer.

What you're lacking here is the join between the order and the detail table so...

Please post the code for the insert that's failing. The "-" in the error looks a little odd. Have you confirmed that the user has insert rights on...

Concatenation operator. Replace the || with +.

Has the 'executed as' user's password expired?

Be careful with float if you need exact answers. Float is an approximate data type and you need to look at BOL and understand what the implications for that...

Your 'in' clause has an opening paren but no closing.

If this really is SQL Server 2000, it could be:

http://support.microsoft.com/kb/909369

What is your setting for 'recovery interval'?

How much memory does it have? If the server and SSMS are fighting for the memory, you may see latency based on the need to swap out the server...

Was the error thrown on the database server or on the client receiving the data? Was there an 'order by' on the select?

You probably need to get new drivers from the vendor. Sometimes, drivers need to get information from the DBMS catalog about the result sets that are returned. Your...

I got this from another post that had one of the same error messages. May or may not apply:

http://support.microsoft.com/kb/303287/

'Real' like 'float' is an approximate data type. There are some numbers that can't be exactly represented. If you need fixed precision, you should probably use numeric(s,p) instead...

what do you get if you run

bcp -v

at the command prompt on the server?