title: SQL using sp_HelpText to view a stored procedure on a linked server
body: <p>Anyone have an idea about how to use sp_helptext to view a stored procedure on a linked server? basically something like this. I don't have the credentials to that linked server to look at it. </p>
  
  <pre><code>EXEC sp_HelpText '[ServerName].[DatabaseName].dbo.storedProcName'
  </code></pre>
  
  <p>thanks ahead.</p>