changing the language that the menus display in SSMS

Question

changing the language that the menus display in SSMS

Duran

SSChampion

Points: 13259
More actions
April 8, 2009 at 8:39 am

#199104

Hello,
I hope someone can help me out. I have an installation of SQL 2005, the OS regional language is English (US), but I cannot change the menus in sql from being displayed in Chinese. What can I do?
Thank you,
D.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

You could change the language you save your .sql files in save as drop down and you could change the collation of the database under options in the database properties. That is all you need to create and use Chinese in SQL Server, to make SQL Server Chinese then you may need to change your OS language to Chinese

Kind regards,
Gift Peddie

Duran SSChampion Points: 13259 More actions · Answer 2

Hello,

Thanks for getting back, what I am after is having SQL server display all its menus etc in English, as I do not understand Chinese. I have been looking into changing the collation, but I do not think that is correct and would cause much disruption.

Regards,

D.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

That would mean you have chosen to install Chinese version of SQL Server in US OS so you need to rerun setup and install English SQL Server with the OS collation and then just use Chinese collation for your database as needed. That is you don't need Chinese SQL Server to store Chinese in a SQL Server database.

Now you must know there are many Chinese defined in SQL Server collation choose the correct one.

http://msdn.microsoft.com/en-us/library/ms143508.aspx

http://msdn.microsoft.com/en-us/library/ms144250.aspx

Kind regards,
Gift Peddie

Duran SSChampion Points: 13259 More actions · Answer 4

Hello,

Thank you againn for your reponse, so if I was to rerun setup and install english, it will not effect anything currently running on the SQL server? I mean in terms of an Stored Procedures etc?

Regards,

D.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

I thought this was new installation so you need to take full backup of all your databases, then when you finish you could check if your stored procs are in Chinese you can just save as English and execute as needed.

There is an arrow in the save popup box click it and you will see all the languages defined.

Kind regards,
Gift Peddie

Duran SSChampion Points: 13259 More actions · Answer 6

ok thank youfor your help, I'll look into this.

Regards,

D.