how to add support for other language in sql server 2005

Question

how to add other language beside default, when i select language for database?

Answer 1

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
RECONFIGURE

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.

---

Anup | Database Consultant

Blog: www.sqlsailor.com Twitter: Follow me !

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 2

Can 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/

Answer 3

Hi zzdravkin,

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?

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.