• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 406
  • Last Modified:

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?
0
himabindu_nvn
Asked:
himabindu_nvn
1 Solution
 
slightwv (䄆 Netminder) 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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now