December 1, 2003 at 10:37 am
I have an instance where SQL2000 was installed with the language set to United States. I need to change this setting to UK permanently.
Databases have been created before I realised that the language was incorrect. What would be the best way forward to resolve?
December 1, 2003 at 12:22 pm
You change the default language for users several different ways. Check out "default language option" in BOL.
You can also change the language for each user session.
Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance.
Patrick
Quand on parle du loup, on en voit la queue
December 2, 2003 at 7:12 am
If I alter the sp_defaultlanguage from US_english to British and run against all databases will this work?
December 2, 2003 at 8:02 am
sp_defaultlanguage is for login.
And you could use "SET LANGUAGE" or reconfigurate the setting of server properties to reset the server level language environment.
December 2, 2003 at 12:47 pm
sp_defaultlanguage would only be for login sessions. If you want to run sp_configure which will change the global configuration options for the server.
Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance.
Patrick
Quand on parle du loup, on en voit la queue
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply