Transaction Rollback

• Howard C. BAchtel-438731

  SSCrazy

  Points: 2384

  More actions

  January 7, 2008 at 8:21 am

  #202046

  If a transaction is active in parallel with another transaction (e.g. SSIS transactions operating in parallel) is required to be rolled back, how is the correct transaction determined to be rolled back? Or is it?

  Thank you,

  Howard Bachtel

• KennyClarck

  Ten Centuries

  Points: 1239

  More actions

  January 7, 2008 at 11:02 pm

  #765579

  For me each transaction is independent therefore you must check each and rollback only the transaction failed.