title: SQL Server OpenQuery Fails with stored procedure
body: <p>I've got a stored procedure which takes two parameters.  I'm trying to use <code>OpenQuery</code> in SQL Server to join on the result set of my stored procedure <code>dbo.TwoDrugs</code>.  The SQL Server is only a local machine with no one else having access.  I'm trying to do</p>
  <pre><code>select * 
  from OpenQuery (AHCTW208D02,'exec [i 3 sci study].dbo.TwoDrugs ''X'',''Y''')
  </code></pre>
  <p>and I get the error</p>
  <blockquote>
  <p><em>Msg 7357, Level 16, State 2, Line 1</em></p>
  <p><em>Cannot process the object &quot;exec [i 3 sci study].dbo.TwoDrugs 'X','Y'&quot;. The OLE DB provider &quot;SQLNCLI10&quot; for linked server &quot;AHCTW208D02&quot; indicates that either the object has no columns or the current user does not have permissions on that object.</em></p>
  </blockquote>
  <p>I can't think of a reason why I wouldn't have permission (since I created the stored procedure), and I configured the server for data access.</p>
  <p>When I run the stored procedure it does in fact return a result set.  Any ideas on what might be the problem with this?</p>