title: "Deferred prepare could not be completed" error when using local database as linked server
body: <p>I created a Linked Server from my local Sql Server, as given in</p>
  
  <p><a href="http://sqlserverplanet.com/dba/local-linked-server" rel="noreferrer">http://sqlserverplanet.com/dba/local-linked-server</a></p>
  
  <p>However when I try to execute a stored procedure in Linked Server, it throws:</p>
  
  <pre><code>Deferred prepare could not be completed
  </code></pre>
  
  <p>error and invalid object name 'table name'</p>