Thank's for the help guys.  It turned out it was a bad dns in ad

Ken

Thanks for the reply.

I did try it with an sql server login, with the same result.

I also thought it was an authentication error, but my initial thought was that something...

Yes I think that is it!! can not believe I missed that. I think my mind was stuck on trying to join the tables by the value in the...

Sorry I should have stated that it is fixed, 6 columns

Edit: Does the number of columns coming from the other table matter?

Ken

If you don't ask you never get an...

I thought I would post the actual error

Server: Msg 8114, Level 16, State 5, Line 1

Error converting data type varchar to int.

Now my understanding is that because this is a...

Thanks for you quick reply.

I figured something like this must be happening.

If I get a truncation error it all works, but if I get an error saying that the string...