title: Linked server reference "Invalid Column Name"
body: <p>In SSMS 2012, I have created a linked server in SERVERA to SERVERB from which I have successfully written queries to multiple tables within the DBB database using a four part reference.</p>
  
  <p>When I try to reference the 'Charge' table in the 'DBB' database with a simple select statement:</p>
  
  <pre><code>SELECT * FROM [SERVERB].[DBB].dbo.Charge
  </code></pre>
  
  <p>I get the following message:</p>
  
  <blockquote>
    <p>Msg 207, Level 16, State 1, Line 1 Invalid column name 'charge_type'.</p>
  </blockquote>
  
  <p>This column exists in the DBB database as 'Charge_Type', however, the collation of SERVERB is case insensitive, whereas the collation of SERVERA is case sensitive (which is where, I believe, my problem lies).</p>
  
  <p>Does anyone have experience with this issue?</p>