Change Server 2003 Language after SQL Server 2008 installed
Posted on 2011-03-15
We've installed Server 2003 R2 x64 however the language/locale settings were not changed to UK English, and were set to US English.
We installed SQL 2008, spent time confurging and setting up, imported our databases, configuring various logins permissions etc... and have realised the mistake.
How do we go about changing the SQL database language to UK / British English? The difference is very important due to the date format etc.
We've gone to the Advanced tab and changed default to British Language, however it explains "specifies the default language for all newly-created logins".
On running the SELECT @@language, @@langid it returns us_english