[thelist] bad sql data

[Robert Vreeland]

<snip>
Ken wrote
I'm not sure what you mean by "out of range" dates. If the dates were not
valid, then they would never have been accepted by SQL Server in the first
place.
</snip>

To clarify, 'out of range':
If you have a date field and the server has it's date format set to US
format, then 13/09/2005 would be invalid as there is no 13th month. Same
value on a server set to European format would go through no problem. As the
sql server is grabbing this expected format from the OS, the setting can
change. The problem comes in using that data. Specifically, we have a
routine that makes a copy of a database. It starts by creating an empty
database from a script then populates it from the selected database, and
since dome of those dates are in the wrong format, it blows up.

Robert