title: SQL Server OpenQuery to Exec command
body: <p>The following query is working fine in SQL Server 2008 R2</p>
  
  <pre><code>select * 
  from openquery(LinkedServerName, 'exec databaseName.dbo.SP_GET_INFO');
  </code></pre>
  
  <p>I'm trying to convert it using exec command, but no luck. </p>
  
  <p>For instance:</p>
  
  <pre><code>exec ('call databaseName.dbo.SP_GET_INFO') at LinkedServerName
  </code></pre>
  
  <p>Always getting a syntax error with this message:</p>
  
  <blockquote>
    <p>Could not execute statement on remote server 'LinkedServerName'</p>
  </blockquote>
  
  <p>Thanks.</p>