title: Collation Problem - SQL Server 2005
body: <p>I would like to understand this error I'm getting on a SQL Server 2005 instance. Error below:</p>
  
  <blockquote>
    <p>Cannot resolve the collation conflict
    between "Latin1_General_CI_AI" and
    "SQL_Latin1_General_CP1_CI_AI" in the
    equal to operation.</p>
  </blockquote>
  
  <p>Both databases included in a simple query have <strong>Latin1 General CI AI</strong>, but had <strong>SQL Latin1 General CP1 CI AI</strong> before. I changed the collation trying to match them but still get the aforementioned error every time I try to join a temp table with a table from a user database. I have no issues creating temp tables.</p>