title: How to check the integrity of the storedprocedures
body: <p>We have a large database containing a lot of stored procedures.
  Now we are updating our database but some stored procedures still use the old structure.
  We've found most of them using 'sp_depends' but some sp's slipped through.</p>
  
  <p>I was wondering if there isn't a way to check all stored procedures. If they call for a column that doesn't exist anymore you get an error.</p>
  
  <p>Thx</p>