Ошибка: Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Cyrillic_General_CI_AS” in the equal to operation.

Решение: в запросе явно указать collation (select * from USERS t1 inner join EVC2.dbo.Users t2 on t1.LAST_NAME = t2.FamilyName collate Cyrillic_General_CI_AS)

)