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?
himabindu_nvnAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
No.  You need to write a script/procedure to execute them in the order you want and parameters you need.
0
 
Mark GeerlingsDatabase AdministratorCommented:
No.

And, even if this would be possible, what kind of business problem would this solve?
0
 
sdstuberCommented:
no,  how could there be?  what would be the parameters for them?  you'd need to generate them and in valid combinations.

0
 
regevhaCommented:
What is the reason behind this requirment ?
0
 
sdstuberCommented:
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.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.