asked on

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

SOLUTION

Daniel_PL

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Daniel_PL

ASKER CERTIFIED SOLUTION

ImprimaIT

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Daniel_PL

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.

ModernMatt

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