title: SQL Server Stored Procedure Compile-time Validation
body: <p>Does anyone know how to get compile time validation of parameters being passed to a stored procedure.  Example If Proc1 calls Proc2 but specifies an invalid parameter name for Proc2.  Currently I find out at run-time.  Is there a way to find out when I'm creating Proc1?</p>
  
  <p>Thanks much,
  Tom</p>