himabindu_nvn
asked on
Is there any script to execute all stored procedures in a database at a time?
Is there any script to execute all stored procedures in a database at a time?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
no, how could there be? what would be the parameters for them? you'd need to generate them and in valid combinations.
What is the reason behind this requirment ?
when you say "all stored procedures"
I'm going to guess you don't really mean "all",
but rather "a known set, possibly large, all contained within a single schema having no parameters or identical parameters"
in this case, the answer is still "no", but you could create a master procedure that invoked them.
for instance, if you have an installation requiring many procedures to be run, they could all be invoked from one.
or some batch process that invokes by a constant Date, or ID.
I'm going to guess you don't really mean "all",
but rather "a known set, possibly large, all contained within a single schema having no parameters or identical parameters"
in this case, the answer is still "no", but you could create a master procedure that invoked them.
for instance, if you have an installation requiring many procedures to be run, they could all be invoked from one.
or some batch process that invokes by a constant Date, or ID.
And, even if this would be possible, what kind of business problem would this solve?