check if stored procedure is valid

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.

However, sproc A has a call to another stored procedure (sproc B). It does not provide enough pa开发者_如何学JAVArameters for sproc B, so I don't see how it's a valid stored procedure.

I want to detect any stored procedures in my database which aren't passing enough parameters to their own stored procedures.

Thankyou, Fidel

Unfortunately, there is no mechanism in SQL Server to test dependencies, parameters etc

You have to search+check, or provide defaults for parameters. You'll only pick it up by testing otherwise.

A good auto complete tool like Red Gate SQL prompt can list parameters + types for you

Note:

It's a long standing problem and there is even a request to MS including this. SP parameter checking is one of the OPTION STRICT suggestions