May 8, 2002 at 10:20 am
Hi.
Can anyone tell me how you change the default language of a SQL 2000 server Installation. such that when run "SELECT @@LANGUAGE" it erturns "british" and not "us_english"
I tried going to the server properties in Enterprise manager and this did not work.
May 8, 2002 at 12:59 pm
quote:
Hi.Can anyone tell me how you change the default language of a SQL 2000 server Installation. such that when run "SELECT @@LANGUAGE" it erturns "british" and not "us_english"
I tried going to the server properties in Enterprise manager and this did not work.
Look in MSDN on line for "Setting Configuration Options"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_3wmr.asp
Also, check in BOL sp_defaultlanguage (T-SQL) for changes of the default language of a login
May 9, 2002 at 2:12 am
Just to make something clear.
I know how to change the default language of a login. But I wanna make this change permanent such that whenever I run SELECT @@LANGUAGE I get 'british' and not 'us_english', for every user that logs in that has not explicitly changed the language
May 9, 2002 at 6:14 am
Sorry, you have to go back and set each existing login to use the new language. Default language only affects new logins.
Excert BOL
quote:
Use the default language option to specify the default language for all newly created logins. To set default language, specify the langid value of the desired language, as listed in the syslanguages table. For more information, see syslanguages
I did test this on my machine with
SELECT @@LANGUAGE
Exsisting was us_english
New was British
SELECT CAST('03/12/2002' AS DATETIME)
Exsisting was 2002-03-12 00:00:00.000
New was 2002-12-03 00:00:00.000
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 9, 2002 at 6:30 am
You deh man! Tnx it worked man. Thank you
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply