[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?
 
Thanks
Robert Vreeland



More information about the thelist mailing list