Save some work within rolled back transaction

• JacekO

  SSCertifiable

  Points: 6610

  More actions

  February 27, 2006 at 7:53 pm

  #90845

  Is there a way to preserve some data that was inserted into the database within a transaction that was rolled back.

  BEGIN TRANSACTION

  DO STUFF1

  DO STUFF2

  DO STUFF3

  ROLLBACK TRANSACTION

  I would like to preserve the DO STUFF2 portion, to treat it as not being a part of transaction. The reason for this: we would like to log within the DB some of the erros and all logical exceptions. The problem is the fact that transactions have this all or nothing approach and there is no way to exclude a portion of the code from being a part of transaction.

  Any ideas, tricks?

  I know I could log to Windows Event log with one of the extended SPs but it goes into Application log which is already overloaded with events.

   

   

   

  ---------------------------------------------
  [font="Verdana"]Nothing is impossible.
  It is just a matter of time and money.[/font]

• Jen-169507

  Right there with Babe

  Points: 776

  More actions

  February 28, 2006 at 10:51 pm

  #623860

  you could log the errors in txt file, a rollback will not roll this back...

  i think... give it a try