Collation Errors Running a SQL Query

If you are ever trying to join tables from different databases that are using different collations you may experience the dreaded… Msg 468, Level 16, State 9, Line 4 Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. The fix for this is fairly simple. In the join part of…

Continue reading →