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