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 su
ch 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...
>