collation

I have a couple of databases that I must change the
collation (from Collation=Latin1_General_CI_AS,
SQLSortOrder=0 to Collation=SQL_Latin1_General_CP1_CI_AS
SQLSortOrder=52) as I have to move them from one server
to another. How can I do that ? Is the rebuilding master
db the only way to transfer them to another server?
Some of the other databases residing on the same server
have the right collation order , can somebody explain how
is that possible.
Thanks for your time!
Mironever done this but you can use ALTER DATABASE to change collation of a DB.
Rebuilding master would affect other DBs as well. Look in BOL for 'Changing
Collations'
hth,
"Miro" <anonymous@.discussions.microsoft.com> wrote in message
news:320e01c3e1f6$42923b70$a001280a@.phx.gbl...

quote:

---

> I have a couple of databases that I must change the
> collation (from Collation=Latin1_General_CI_AS,
> SQLSortOrder=0 to Collation=SQL_Latin1_General_CP1_CI_AS
> SQLSortOrder=52) as I have to move them from one server
> to another. How can I do that ? Is the rebuilding master
> db the only way to transfer them to another server?
> Some of the other databases residing on the same server
> have the right collation order , can somebody explain how
> is that possible.
> Thanks for your time!
> Miro

---