Change Default Langauge for a database

Hello All,
We have an SQL Server installation setup with US english as the default
language. Now we need that one of the databases use British english as the
default language for that database, but I have not been able to find an
option to do so in the SQL Server management interface, is there a way to do
that ? if so how can it be done.
Thanks a lot.
Imran.Default language is set at the login level. If you don't specify a language for a login, then a
system default is used, which you can set using sp_configure. There is no such thing as default
language for a certain database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Imran Aziz" <imran@.bindweb.com> wrote in message news:uGUhRRdsEHA.2560@.tk2msftngp13.phx.gbl...
> Hello All,
> We have an SQL Server installation setup with US english as the default language. Now we need
> that one of the databases use British english as the default language for that database, but I
> have not been able to find an option to do so in the SQL Server management interface, is there a
> way to do that ? if so how can it be done.
> Thanks a lot.
> Imran.
>|||Thanks a lot for the response, that sorted my problem :)
Imran.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OW5edVdsEHA.3412@.TK2MSFTNGP14.phx.gbl...
> Default language is set at the login level. If you don't specify a
> language for a login, then a system default is used, which you can set
> using sp_configure. There is no such thing as default language for a
> certain database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Imran Aziz" <imran@.bindweb.com> wrote in message
> news:uGUhRRdsEHA.2560@.tk2msftngp13.phx.gbl...
>> Hello All,
>> We have an SQL Server installation setup with US english as the
>> default language. Now we need that one of the databases use British
>> english as the default language for that database, but I have not been
>> able to find an option to do so in the SQL Server management interface,
>> is there a way to do that ? if so how can it be done.
>> Thanks a lot.
>> Imran.
>sql

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

Change Collation in database/server

Hello group,
Hi everyone I localize aplication to polish language and I want change
collation in database.
How change Collation in data base?
My database name MyDB
I want collation : 'Polish_CI_AS'
And my second question:
How set default collation for server (for new databases) if the collation is
different as operation system (ex. polish collation in databese, on windows
server english version)?
Thanks
PawelRHave you read these:
You can start here:
http://msdn.microsoft.com/library/d...br />
1pwz.asp
Default collation:
http://msdn.microsoft.com/library/d...br />
0f3n.asp
Changing collations:
http://msdn.microsoft.com/library/d...br />
819v.asp
ML|||ALTER DATABASE MyDB COLLATE <collationName>
"PawelR" wrote:

> Hello group,
> Hi everyone I localize aplication to polish language and I want change
> collation in database.
> How change Collation in data base?
> My database name MyDB
> I want collation : 'Polish_CI_AS'
> And my second question:
> How set default collation for server (for new databases) if the collation
is
> different as operation system (ex. polish collation in databese, on window
s
> server english version)?
>
> Thanks
> PawelR
>
>