August 11, 2006 at 7:03 am
Hi all. I have setup a 2003 svr with sql2k. I neglected to change the lanuage settings on 2003 before i installed sql2k now the database is using american date format instead of british. I have changed the 2003 settings and gon through the registry to change settings but the databse still shows the language as english united startes. Can anyone let me know how i change the language please.
many thanks
Kevin
August 11, 2006 at 7:16 am
To change the default langauge for users open Enterprise Manager to the server in question, right click on the server itself and choose properties. Change to the "Server Settings" tab and you will see it there, choose OK and restart SQL Server if it doesn't do itself.
Now for you existing users again open Enterprise Manager and drill to your server then to Secuirty->Logins. Open each existing user and you will see the Language selection on the bottom of the dialog. Press OK to change. Or look at my script here to change all the existing user accounts in one bang.
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=325
August 11, 2006 at 7:40 am
Thanks for the info. Tried what you suggested but on the the properies in the geneal tab its still showing English(United States) andn when i try and do what i need to do its still using the US date format. Any more idea??
Kev
August 11, 2006 at 7:40 am
Thanks for the info. Tried what you suggested but on the the properies in the geneal tab its still showing English(United States) andn when i try and do what i need to do its still using the US date format. Any more idea??
Kev
August 11, 2006 at 8:09 am
You stated you are using SQL 2000. When I look at any databases properties I don't see anything about language. I see
Database----------------
Status
Owner
Date created
Size
Space available
Number of users
Backup------------------
Last database backup:
Last transaction log backup:
Maintenance--------------
Maintenance Plan:
Collation name:
There is nothing about language. Are you using SQL Sever 200 Enterprise Manager or what?
August 11, 2006 at 8:14 am
Nevermind I see now.
That is the product information and has nothing to do with the language for users. You installed the English version of the product.
That is like running in QA
SELECT @@Version
run
SELECT @@LANGUAGE
to see what laguage it is providing.
I don't recall a product language choice on the install, it was based on the version of the product you purchased.
August 11, 2006 at 8:17 am
Sorry doesn't come from SELECT @@Version, may come from the executable. Cannot find reference to where this value resides but again is the product installed and nothing to do with the user language.
August 11, 2006 at 8:23 am
Thnaks again. Ran QA as you suggested and it does come back as British. So there must be something else going on here.
Kev
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply