transaction not rolling back

• chisholmd

  SSCrazy

  Points: 2490

  More actions

  March 24, 2004 at 5:24 pm

  #500341

  What I don't know never ceases to amaze me.

  Thanks Hanslindgren, If I understand correctly this is what I have been looking for.  Most of my transactions are the type where if any one of the statments fails to complete I want to roll back all of them.

  So all I have to do is

  SET XACT_ABORT ON

  begin tran

  ...do stuff..

  commit tran

  If any of my statements fail to complete, <ahem> (raise a run time error) then they are all rolled back and the transaction is terminated. Perfect.

   

   

   

   

   

  Dave

  Trainmark.com IT Training B2B Marketplace
  (Jobs for IT Instructors)