70-433 · Question #94
You have an application that is used by international clients. All clients connect by using Windows Authentication. You need to ensure that system and user-defined error messages are displayed in…
The correct answer is B. Use default language for each login C. Use @lang parameter of sp_addmessage. sp_configure is used to specify the default language for all newly created logins. CREATE LOGIN expression has DEFAULT_LANGUAGE = language option. It specifies the default language to be assigned to the login. If this option is not included, the default language is set to the…
Question
You have an application that is used by international clients. All clients connect by using Windows Authentication. You need to ensure that system and user-defined error messages are displayed in the localized language for the clients. What should you do? (Each correct answer represents part of the solution. Choose two.)
Options
- AUse @@LANGUAGE function
- BUse default language for each login
- CUse @lang parameter of sp_addmessage
- DUse the "set language" option of sp_configure
How the community answered
(24 responses)- A13% (3)
- B79% (19)
- D8% (2)
Explanation
sp_configure is used to specify the default language for all newly created logins. CREATE LOGIN expression has DEFAULT_LANGUAGE = language option. It specifies the default language to be assigned to the login. If this option is not included, the default language is set to the current default language of the server. sp_addmessage stores a new user-defined error message in an instance of the SQL Server Database Engine. One of the options is 'language. It is the language for this message, that is the language in which message is written. When language is omitted, the language is the default language for the
Topics
Community Discussion
No community discussion yet for this question.