Transaction Management

  • I have two question ..

    1) What's is transaction management ?? how we can achive it in t-sql block or in stored proc ?

    2) I have three stored porc

    Proc_A , Proc_B, Proc_C

    if Proc_A is calling Proc_B , Proc_B calling Proc_C , Proc_C calling Proc_A , what will happne ??

    3) is question 2 have any relation with question 1 ??

    Thanks

  • 1) probably easiest if you look up something like 'Begin Transaction' in BOL to get a general understanding but simply, a transaction is a single unit of work that either completes successfully, commiting changes, or doesn't commit successfully and therefore changes are rolled back.

    3) Standard DBA response - Depends!!  If you control the flow within a Tranascation then 2) does depend on 1)

    As i said, if you have a read of BOL and then post any other questions in this forum to clear up any other points.

     

     


    Growing old is mandatory, growing up is optional

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

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