|
Home > Archive > MS SQL Server > February 2006 > SQL 2005 Server Properties - Language
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL 2005 Server Properties - Language
|
|
|
| I have just installed a new SQL 2005 server on a Windows 2003 server with
regional settings set to English (United Kingdom). Despite the setting on the
underlying server the SQL 2005 server displays it's language as being English
(United States) in the server properties screen (greyed out).
I have change the default language for the server to English (United
Kingdom) using sp_configure 'default language', '23'. Although this appears
to have worked OK the server properties screen is still confusingly
displaying English (United States).
Has anyone else encountered this problem ?
Is there any was to ensure that the language is set correctly at
installation ?
Regards,
Karen
| |
| Tibor Karaszi 2006-02-28, 8:23 pm |
| Seems like the value you see in that dialog is the language for the installation CD you installed
from. I took a Profiler trace and the dialog calls xp_msver and the documentation indicates that
this is what language means.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"Karen" <Karen@discussions.microsoft.com> wrote in message
news:D962C978-F836-488C-A292- D8CD0DEB5BCA@microso
ft.com...
>I have just installed a new SQL 2005 server on a Windows 2003 server with
> regional settings set to English (United Kingdom). Despite the setting on the
> underlying server the SQL 2005 server displays it's language as being English
> (United States) in the server properties screen (greyed out).
>
> I have change the default language for the server to English (United
> Kingdom) using sp_configure 'default language', '23'. Although this appears
> to have worked OK the server properties screen is still confusingly
> displaying English (United States).
>
> Has anyone else encountered this problem ?
>
> Is there any was to ensure that the language is set correctly at
> installation ?
>
> Regards,
> Karen
|
|
|
|
|