change sql 2000 server collation

Hello,
Is there a way to change the collation of a sql2000 from
Latin1_General_CS_AI to Latin1_General_CI_AI?
thanks
WilfridIf you have to change the collation on server level meaning the collation of
master database then you will have to rebuild the master database. You can
change the collation of user databases by creating a new database with
desired collation and then transferring data from old database to new
database. Here is a microsoft article which describes it in detail:
http://support.microsoft.com/?kbid=325335#8
Bob
"Wilfrid" wrote:

> Hello,
> Is there a way to change the collation of a sql2000 from
> Latin1_General_CS_AI to Latin1_General_CI_AI?
> thanks
> Wilfrid
>
>