Post reply

transaction not rolling back

  • 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)

Viewing post 16 (of 15 total)

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