Rolling back a doomed transaction

• dndaughtery

  SSChampion

  Points: 11290

  More actions

  July 27, 2010 at 2:49 pm

  #141240

  I have a trigger that errored out and didn't have the Rollback command in the catch. I'm getting the following error:

  4710515 - Error #: 3930 Error Severity: 16 Error State: 1 Error Line: 20 Error Message: The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.

  I believe this is a doomed transaction from what I've been able to find online. How can I manually rollback the trans action?

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  July 27, 2010 at 9:14 pm

  #1199058

  Try to make use of TRY/BEGIN, CATCH in the trigger.

  Also XACT_STATE can be used for rolling back.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga