title: check if stored procedure is valid
body: <p>I have a stored procedure (sproc A) which is syntactically correct. So when I hit "run" on its create or alter statement, it is saved into the database.</p>
  
  <p>However, sproc A has a call to another stored procedure (sproc B). It does not provide enough parameters for sproc B, so I don't see how it's a valid stored procedure.</p>
  
  <p>I want to detect any stored procedures in my database which aren't passing enough parameters to their own stored procedures.</p>
  
  <p>Thankyou,
  Fidel</p>