I was wondering how to change the language settings on SQL Server. The server is currently set to US English, and I was wondering how it is possible to change it to UK English. The Server Regional Settings are set to UK English.
Also, on a semi-related topic, does SQL Server store dates in a universal format, and then when data is requested does it 'translate' these dates into the format required by that particular regional setting?
Not sure on the first question, but as far as dates are concerned, yes, they are stored in , I believe, integer format, and converted to whatever date format 1) you client uses, or 2) you ask for via CONVERT statement.