After resolving a @variable table JOIN issues, I was trying to JOIN usernames between two different databases when up pops a big:
Cannot resolve the collation conflict between "Latin1_General_CI_AS_KS_WS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

 

Pinal Dave to the rescue again:
http://blog.sqlauthority.com/2007/06/11/sql-server-cannot-resolve-collation-conflict-for-equal-to-operation/

 

 

Yup, when joining two databases, you may have to use:
COLLATE DATABASE_DEFAULT

Advertisements