Change Database Language

i using sql server Express, i want to change the default language from US-English to British English
Where and How?

If you have the SQL management Studio you can do that easily . Right click on the database and change the collation of the database.

HTH
Regards

|||

hongcw83:

i using sql server Express, i want to change the default language from US-English to British English
Where and How?

Another option is to use the locale ID configuration so you change from US to UK as in the link below, that includes the collation change as noted by Smiling4ever. Hope this helps.

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

|||You can?simply use sp_configure to change the default language setting, check this post:
http://forums.asp.net/thread/1349363.aspxsql