SQL Server Date Format

[BiggerD]

How does the Server decide on what date format you are using i.e 22/01/03 causes a date time conversion error as the Server (2000) seems to be expecting an American format but on a SQL Server 7 it accepts the data and works with it as it should. I can get round this by uising 22 Jan 03 but this does not resolve why the problem occurs and a proper way of resolving the issue.
Can anyone Help ?

 

[aolb]

Check the Regional Settings on the server SQL server is running on. This is where the Date format is taken from.

You might find 'SET DATEFORMAT dmy' useful. It is used when converting a string to a datetime and you want to set the format.

 

[BiggerD]

The answer it seems does not lie in any of the usual suspects rather in the Security option within the SQL Server then Logins and right click the user(s) in question select properties and set the Default Laguage setting to you chsen selection, this has fixed my problem in question.