SQL Server Stored Procedure Compile-time Validation <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>