Post reply

Stored Proc that Fires Other Stored Proces

  • August 24, 2006 at 10:41 am

    #113480

    MSSQL 2000

    I have a Stored Proc that fires off several other SP's.  Will it fire each one simultaneously, or will it wait until the preceeding one has finished?

    Ultimately, I need it to execute in steps, one at a time.  Each SP is dependant upon the results of each execution before it.  I cannot put all the code together since each step is used in other SP's.

    I hope that I've made sense.

    Thanks!

  • August 24, 2006 at 10:44 am

    #656651

    will wait untill execution of the called sp is completes.

  • August 24, 2006 at 12:28 pm

    #656678

    To add to this.. The only way to run procs at the same time is to create another connection and have that connection run the next proc...

     

    Unless yukon figured out a way around that??

  • August 24, 2006 at 2:00 pm

    #656709

    Thanks for the replies!

  • August 26, 2006 at 5:09 pm

    #657010

    If you want to run multiple SP's at a time another option would be SQL Jobs. Each job can fire individual SP & finally LOG the completion status into some table which can be used by Parent SP to see if all SPs' are compalted execution...


    paul

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply