Post reply

Need to ecexute the order of SPs to be executed using scripts

  • July 16, 2008 at 11:18 pm

    #188198

    Hi all,

    I have a list of aroud 750 SPs. Some SPs are calling other SPs inside the code. So while creating the SPs I have to create the dependant SPs first. I am using the osql option for creating the SPs. Is there any way to find out the order of executing the SPs.

    Please help....

    Thanks

    Aneesh

  • July 16, 2008 at 11:34 pm

    #844147

    There is no need to sequence the stored procedures. When you create the stored procedure using osql and dependant stored procedure is not available then you will get the waring message stating "Stored procedure is created but could not executed as dependant object is not available ".. something like that so you dn't worry abt that.

Viewing 2 posts - 1 through 1 (of 1 total)

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