Collation Problem on Sql Server 2000

Hi all,
My database's collation setting is Turkish_CI_AS and I need to change as
SQL_Latin_General_CP1_CI_AS
which I use command for this operation as follows
"Alter Database [ORDER] collate SQL_Latin_General_CP1_CI_AS"
but I have error message like that :
Server: Msg 5030, Level 16, State 2, Line 1
The database could not be exclusively locked to perform the operation.
Server: Msg 5072, Level 16, State 1, Line 1
ALTER DATABASE failed. The default collation of database 'ORDER' cannot be
set to SQL_Latin1_General_CP1_CI_AS.
so how can I solve tihs problem and how can I turn my collation setting as
SQL_Latin_General_CP1_CI_AS
thanks for helps.ss
It is not going to be an easy task ,because sql server will throw an error
of you hasve any indexes on those columns , so first thing I'd remove all
indexe and the run
ALTER TABLE ... ALTER COLUMN ... statement
Moreover if you issue ALTER DATABASE ...COLLATION... all objects that have
an 'old' collation will not be affected
"ss" <ss@.ss.com> wrote in message
news:ur$XkyLoGHA.4332@.TK2MSFTNGP03.phx.gbl...
>
> Hi all,
> My database's collation setting is Turkish_CI_AS and I need to change as
> SQL_Latin_General_CP1_CI_AS
> which I use command for this operation as follows
> "Alter Database [ORDER] collate SQL_Latin_General_CP1_CI_AS"
> but I have error message like that :
> Server: Msg 5030, Level 16, State 2, Line 1
> The database could not be exclusively locked to perform the operation.
> Server: Msg 5072, Level 16, State 1, Line 1
> ALTER DATABASE failed. The default collation of database 'ORDER' cannot be
> set to SQL_Latin1_General_CP1_CI_AS.
> so how can I solve tihs problem and how can I turn my collation setting as
> SQL_Latin_General_CP1_CI_AS
> thanks for helps.
>
>