Good point - not all of us are in the US   (I'm in Australia - we use dd/mm/yyyy)

Is there a way to change the default for SQL server at the

a) Server level

b) database level

c) logon level?

I've got an app from the US which fails at one particular point because it submits a date using dd/mm/yyyy but SQL wants mm/dd/yyyy - at all other points it uses the yyyy-mm-dd syntax..  Driving me nuts!   Sorry for irrelevant post - been wasting my time on it lately and this thread reminded me of it