Change Server 2003 Language after SQL Server 2008 installed

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
ImprimaITAsked:
Who is Participating?
 
ImprimaITConnect With a Mentor Author Commented:
We reinstalled SQL
0
 
Daniel_PLConnect With a Mentor DB Expert/ArchitectCommented:
Changing server default collation is not possible just like that, it implies rebuidling master database :/
http://msdn.microsoft.com/en-us/library/ms179254%28v=SQL.100%29.aspx
0
 
Daniel_PLDB Expert/ArchitectCommented:
Why question should be closed? Answer provided is enough to tell
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.

Reinstallation... it's obvios that you can set everything from scratch. Question was how to change server collation.
0
 
ModernMattCommented:
Daniel_PL provided an alternative solution which involves rebuilding the master database. I am going to accept the author's comment which references reinstallation, but award points to Daniel_PL for posting an alternative solution.

ModernMatt
Experts Exchange Moderator
0
All Courses

From novice to tech pro — start learning today.