I had the same problem when we upgraded from SQL Server 7 to 2000, the install for 2000 used the default collation but the backups we restored from 7 used...