title: SQL Server 2008 Collation conflict - how to resolve?
body: <p>For simplification, POC, I have the following query, using character typed columns:</p>
  
  <pre><code>select AH_NAME1 from GGIMAIN.SYSADM.BW_AUFTR_KOPF
  union
  select AH_NAME1 from GGI2014.SYSADM.BW_AUFTR_KOPF
  </code></pre>
  
  <p>and I get the following error:</p>
  
  <blockquote>
    <p>Msg 468, Level 16, State 9, Line 2<br>
    Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CS_AS" in the UNION operation.</p>
  </blockquote>
  
  <p><code>GGI2014</code> was indeed created with collation <code>SQL_Latin1_General_CP1_CI_AS</code>. This has been changed in SMS and the instance has been restarted, also in SMS.</p>
  
  <p>When I look in SMS, as well as query:</p>
  
  <pre><code>select name, collation_name from sys.databases
  </code></pre>
  
  <p>all indications are that both <code>GGIMAIN</code> and <code>GGI2014</code> are collated <code>Latin1_General_CS_AS</code>.</p>
  
  <p>Does anyone have any advice on what else needs to be done?</p>
  
  <p>Thanks,</p>
  
  <p>Matt</p>