Tuesday, March 13, 2012 10:55 PMhow to add other language beside default, when i select language for database?
Tuesday, March 13, 2012 11:23 PM
You can change the entire server default language, one login or one sessions language.
To change the default language of the server
EXEC sp_configure 'default language', 9
To change the default language of a login:
ALTER LOGIN sa WITH DEFAULT_LANGUAGE = French;
To change the language in a session:
SET Language French
If you are expecting the server messages in a different language than US English,then that localized version of SQL server should have been installed.
Wednesday, March 14, 2012 6:47 AMCan you clarify what are you trying to achieve?
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Thursday, March 15, 2012 8:10 AMModerator
If you wanna change SQL Server management studio language, please refer to How to: Set the Default Language (SQL Server Management Studio)And for database&login you can refer to How to set the default language & default database for a login?
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- Marked As Answer by Iric WenModerator Wednesday, March 21, 2012 6:03 AM