[thelist] bad sql data

Robert Vreeland vreeland at studioframework.com
Sun Nov 27 13:20:21 CST 2005

Hello all,
Here is the problem:
Our app and backend ms sql is designed to run on a server in a US time zone.
One of our clients reset their server to a European time zone, we caught it
and set it back. The problem is now the date fields are mixed - some US and
some European. My question is, how can I get the sql server (ms sql 2000) to
test / report on / for out of range dates?
Robert Vreeland

More information about the thelist mailing list