title: Query the contents of stored procedures on SQL Server
body: <p>I am exploring a legacy database system and have very little knowledge of its internals. I would like to find all the stored procedures that invoke another stored procedure <code>A</code>.</p>
  
  <p>How best to do this?</p>
  
  <p>Can I write something like this pseudocode:</p>
  
  <pre><code>select name from AllStoredProcedures as Asp where Asp.TextualContent contains 'A'
  </code></pre>
  
  <p><code>Asp.TextualContent</code> means the actual SQL contained in the SP.</p>