December 13, 2005 at 3:37 am
I am installing SQL 2000 and selecting a custom installation. I need to change the langauge to British English but cannot seem to find this in the installation screen. The windows local is setup properly (to British English on a Windows 2003 server). if I select the properties in Enterprise manager of the instance you can see that the language is set to English (United States) on the GENERAL tab. On the Server Settings tab the option (default langauge for user) can be set correctly to British English. This is also the option that can be set using sp_configure but nowhere can I find the option to change the general tab "setting". Is this a red herring by any chance? I ask as if I run the following all looks well....
select name ,alias, dateformat
from syslanguages
where langid =
(select value from master..sysconfigures
where comment = 'default language')
the valuse returned are;
British, British English, DMY
Can anyone please help as I need to be sure and this is driving me mad.
thanks in advance.
Mike
This is basic I know but I can't seem to find the option to change this.
December 14, 2005 at 12:57 am
From Books Online (BOL):
To set the default language
The default language is English.
Andy
March 10, 2006 at 11:41 am
so...not actually reading the question before replying then.....not very useful
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply