Friday, February 17, 2012

Different behavior between 2 installs of SQL Server 2000 !

Hi,
anyone could explain this : I have installed the same asp.net application on 2 distinct hosts, each with its own SQL Server 2000 database.
However, in some SQL queries in Stored Procedures, the results do not come out the same.
For example, on one server the query "select @.value = (select ...)-(select ...)" works and on the other one it returns a null value
Any hint ?
Thanks for your help
Johannoff the top of my head - does one have a different setting for, say, case-sensitivity?
|||

Well, I don't know about this since I am using distant hosting services.

However, the Stored Procedures are identical since I did an automatic install of both databases using one SQL script.

So ...

No comments:

Post a Comment