title: How to see which stored procedures are affected by changing schema name
body: <p>I am in the process of changing the schema of a couple of tables. Currently all the tables are in the dbo schema and need to be moved into a different schema. </p>
  
  <p>I have run the following script ( on many tables):</p>
  
  <pre><code>ALTER SCHEMA client TRANSFER dbo.Companies
  </code></pre>
  
  <p>The issue I have now is that there are stored procedures that ned to be updated to use the correct table name</p>
  
  <pre><code>dbo.Companies -&gt; client.Companies
  </code></pre>
  
  <p>Is there any way one can check which stored procedures need to be checked and fixed?</p>