Verify the stored procedure

I have a stored procedure (sproc A) that is syntactically correct. Therefore, when I click "run" on my create or alter statement, it is saved in the database.

However, sproc A has a call to another stored procedure (sproc B). It does not provide sufficient parameters for sproc B, so I do not see how this is a valid stored procedure.

I want to detect any stored procedures in my database that do not pass enough parameters to their own stored procedures.

Thankyou, Fidel

+3
source share
1 answer

Unfortunately, there is no mechanism in SQL Server for checking dependencies, parameters, etc.

+ . , .

, Red Gate SQL +

:

, MS, . SP OPTION STRICT

+5

All Articles