xact_abort on

• Ghanta

  Hall of Fame

  Points: 3999

  More actions

  March 28, 2008 at 2:56 pm

  #183923

  If you run updtes in batches and use

  set xact_abort on -- rollback and bail on error set implicit_transactions off -- ensure we're running under the default (autocommit) mode

  say for some reason you have to kill the update, will it try to rollback all the batches or just the last batch? Coz it will take a long time if it tries to rollback all the batches.

  Thanks!

• Mohan Kumar

  SSCertifiable

  Points: 5365

  More actions

  March 28, 2008 at 9:43 pm

  #795563

  It will rollback last batch only.

  [font="Verdana"]--www.sqlvillage.com[/size][/font]