Не меняется язык в SSMS. Как исправить?
Установила MICROSOFT SQL SERVER 2019 и MANAGEMENT STUDIO 18, при обеих установках был выбран русский язык, но отображается функционал на английском языке: 
В свойствах сервера указан русский язык: 
How to change default language for SQL Server?
John Woo’s accepted answer has some caveats which you should be aware of:
- Default language setting of a T-SQL session in SQL Server Management Studio(SSMS) is inherited/overriden from/by Default language setting of the user login used to initiate the session instead. A new tab in SSMS creates a new T-SQL session. SQL Server instance level setting does not control the Default language setting of T-SQL session directly.
- Changing Default language setting at SQL Server instance level has no effect on the Default language setting of the already existing SQL Server logins. It is meant to be inherited only by the new user logins that we create after changing the instance level setting. So don’t be surprised if you changed the Default language setting at SQL Server instance level but it didn’t take effect for your user account. It is as per design.
So, there is an intermediate configuration level between SQL Server instance level and the T-SQL session level. It is called user login level. You can use this intermediate level configuration to control the Default language setting for T-SQL session without disrupting the SQL Server instance level settings.
This intermediate level setting is very helpful in case you want to set Default language setting to some value for all new T-SQL sessions(tabs in SSMS) belonging to some specific user.
We can change the Default language setting of the target user login as per this link. You can also achieve it from SSMS console e.g. we can change the Default language setting from the properties window of sa user in SQL Server via SSMS (Refer screenshot):
Note: Changing the setting at user login level will not affect the setting of already active tabs in SSMS. It will affect only the new tabs which will be opened after changing the setting.
Setting & working with language in SQL SERVER
In this tutorial, learn how to work with different languages in SQL Server. Learn how to change SQL server language settings. Find out the language list that SQL server supports along with the language codes & language id etc. We also lean how to change the language settings in case of contained database.
Table of Contents
Finding the Current Language
@@LANGUAGE global variable returns the name of the language that sql server uses currently.
Finding the language List
To find the list of languages that SQL Server supports run sp_helplanguage stored procedure without any parameter
It will list the langid (language id), name (language name) etc.
Language Settings in SQL Server
How you set the language of a database depends on whether it is a contained database or not.
A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database. This SQL Server introduced this feature since version 2012.
If the database is not contained then the settings needs to change at instance level and at login account.
In case of contained database, you need to set it for the database & database user account.
We look at the both the scenarios.
Setting Language for SQL Server / Instance
In SQL Server language can be set at three places.
- Instance
- User Login Account
- Current Session
SQL Server always uses the language set in the current session. If it not set then it uses the default language from the users login account.
The Instance Level language settings are used as the default language when we create a new login account.
Instance Level Language Settings
The SQL Server picks up the language settings from the OS at the time of installation We can change this later either using the
Как перевести sql server на русский язык
This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.
Answered by:
Question
My Windows language is Chinese Simplified.
I installed SSMS-Setup-ENU.exe and found the interface language was English, so I uninstalled it and installed SSMS-Setup-CHS.exe, but the interface language is still English.
How to solve this problem.
Answers
I have found the solution!
1. uninstall "Microsoft Visual Studio 2015 Shell (Isolated)".
2. repair SSMS to install Chinese version "Microsoft Visual Studio 2015 Shell (Isolated)".
But I think you Microsoft should provide detailed information for the localization, or make a better Setup. The truth is, If I reinstall another language of SSMS-Setup, the interface language is still not changed!!