Cannot retsore to new server

Hi,
I'm moving an SQL server from one machine that's about to die onto
another, but the restore of databases fails with an error that the
Unicode comparison style should be 0, not 196609.
Can this be changed or does the SQL server need to be reinstalled?
Thanks
IanHi,
Are you doing the restoration in SQL 7.0 version, if it is SQL 7 then the
source and destination server must of same collation. If it is
SQL 2000 then it will not be an issue.
Thanks
Hari
SQL Server MVP
"Ian T" <ian@.nospam.com.au> wrote in message
news:OkEcjv6wEHA.1984@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I'm moving an SQL server from one machine that's about to die onto
> another, but the restore of databases fails with an error that the Unicode
> comparison style should be 0, not 196609.
> Can this be changed or does the SQL server need to be reinstalled?
> Thanks
> Ian