>Hi all!
>
>I installed a new SQL Server 2000 and restored the tables from the old SQL 2000 Server to the new one. Upon running the the following...
>
>insert DYNAMICS..RecoveryMaster (name, password)
> select name, password from master..sysxlogins
> where name in (select USERID from DYNAMICS..SY01400)
> and name not in ('sa', 'DYNSA')
>
>I get the error: Cannot resolve collation conflict for equal to operation.
>
>I know there is nothing wrong with the script, cause it executes perfectly on the old server. I am thinking that there is something wrong with the new SQL Server installation. How do I determine the problem and ofcourse... how do I fix it?
>
>Thanx! a lot in advance 8 )
>
>Martin

Hi Martin,

Do you have the same collation order on the name fields in table sysxlogins and sy01400? You cannot join 2 fields with different collation order.

Try create a copy of sy01400 with the right collation and run the query again.