title: Duplicate column name... but only if database is case insensitive
body: <p>I'm trying to query a view on a database that has case sensitive collation from a linked server connection. Something else to note is the view I'm trying to query is basically a wrapper to three indexed views.  </p>
  
  <p>The error i'm getting is:</p>
  
  <blockquote>
    <p>Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name "ExtPrice" is a duplicate.</p>
  </blockquote>
  
  <p>In the view I have <code>EXTPRICE</code> as well as <code>ExtPrice</code>. When I query this view from the server directly, I don't have any issues... but when I try to use the query via a linked server, I get the above error.  </p>
  
  <ul>
  <li>Is this a collation issue?  </li>
  <li>How do I use this view via a linked server and still have the query understand that the view is case sensitive?  </li>
  </ul>
  
  <p>I apologize in advance if this is a stupid question.</p>