I created the temp tables and one created as char(26) and the other as datetime. So, how do I go about fixing this issue?

All boxes are set the same.

I think I am going to go down the path of getting the boxes in sync and seeing if that gets things in line. ...

All boxes are Server 2003

This is the one that doesn't work

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation ...

Yes the are both linked to the same server

Would one being Enterprise Edition and the other being Standard Edition cause the issue?

8.00.2039SP4Enterprise Edition

8.00.2039SP4Standard Edition

Chris,

I understand how to get it to work. The question I have is the other two SQL 2000 boxes the query runs on works fine without any changes.

The are both the same

2008-03-06 00:00:00.000

This works on a different SQL Server 2000 box with different version of SQLSRV32.DLL. I believe it is a configuration issue and nothing with the statement. It...

I am running the query against the same database