SQL server 2000 reporting bad values to ASP.Net Application
Posted
by
Ben
on Server Fault
See other posts from Server Fault
or by Ben
Published on 2011-02-05T16:44:27Z
Indexed on
2011/02/05
23:27 UTC
Read the original article
Hit count: 280
sql-server-2000
I have an instance of SQL server 2000 (8.0.2039) with a rather simple table. We recently had users complain about an application I wrote returning bad values for some of the dates in the databse. When I query the table directly via Server Management Studio, it will return the correct values, however the identical queries from my application report the wrong values, but only for a couple of dates.
I have been over the code, and it is solid. If the error was in the code, all of the dates reported should be wrong. I have also run the code on an identical test database, and everything is reported properly. I believe the problem may lie in the sql instance itself, which is why I am posting in Server Fault.
My question is, has anyone heard of a database reporting bad (incorrect) date values when queried via web application? It should be noted that this particular server was once manually rebuilt after having a cluster clean run on it.
© Server Fault or respective owner