I have as SQL Server 2000 running on a Windows 2003 box
I use a c# windows application accessing the database running from an
XP machine also with UK locale settings.
The windows server is set to have British Locale settings but my
field of type datetime is accepting the US format i.e. mm-dd-yyyy
Thus entering a date of 14/12/2005 generates a
System.Data.SqlException
Can I set my SQL Server such that datetime objects use dd-mm-yyyy
rather than mm-dd-yyyy
TIA
I'm new to database stuff so sorry if this is a dumb question :-)