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
Fidel source
share