title: Unable to Query a View from a Linked SQL Server
body: <p>In SQL Server Management Studio, I have linked a SQL Server, <code>sql02</code> to my local server as such:</p>
  
  <pre><code>sp_addlinkedserver 'sql02'
  GO
  </code></pre>
  
  <p>I can query tables from this server:</p>
  
  <pre><code>SELECT * FROM SQL02.SomeDatabase.dbo.SomeTable
  </code></pre>
  
  <p>However, when I try to query a view, as in</p>
  
  <pre><code>SELECT * FROM SQL02.SomeDatabase.dbo.SomeView
  </code></pre>
  
  <p>I get the following error message:</p>
  
  <pre><code>Msg 7314, Level 16, State 1, Line 1
  The OLE DB provider "SQLNCLI10" for linked server "SQL02" does not contain the 
  table ""SomeDatabase"."dbo"."SomeView"". The table either does not exist or the
  current user does not have permissions on that table.
  </code></pre>
  
  <p>Agreed that <code>SomeView</code> does not exist as a table. What am I doing wrong?</p>
  
  <p>Potentially relevant facts:</p>
  
  <ul>
      <li>Local version of SQL Server is 10.50.1617</li>
      <li>Version of linked server is 8.0.2282</li>
      <li>I can SELECT from all the underlying tables in the view</li>
  </ul>