>Is there a setting in SSMS which controls the date format? I have a script which used to work for years but on a client site, it doesn't has it says that this creates a value which is off limit. This seems to be related to the INSERT line of the script which is built from a specific date format.
SET DATEFORMAT
But as Naomi already said change the script (not only this on the client) to use ISO format.
That way you wouldn't care anymore what is the current setting on client machine.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.