June 26, 2003 at 11:35 pm
I have two SQL Server 2000 Enterprise Edition SP3 servers that I believe to be identical.
Using a single application against two databases on each of the servers react differently to NULLs in concatenated strings between servers. That is, databases on SERVER-A will show a string value for a NULL concat, databases on SERVER-B return NULL for the concat.
I have checked the databases for 'concat null yields null' and both report false (using Query Analyzer). I'm lead to believe that this is a misleading value as it's specific to the connection?
The application is using a DSN-less ODBC connection that is identical for each server. I don't have access to the source for the applications.
If anyone has ideas of other things to check, I'd appreciate any help.
June 27, 2003 at 3:37 am
Maybe you could run Profiler to monitor the SQL statements beeing executed by your application? If everything is identical they should execute the same kinds of statements but it could always be something to check (if they for example execute some arbitrary SET CONCAT_NULL_YIELDS_NULL ON or OFF statements on their connections)...
/Hans
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply