Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.

• allarmi

  SSC Enthusiast

  Points: 101

  More actions

  July 16, 2015 at 8:02 am

  #150404

  Hello,

  is there any way to have sqlserver to terminate the current batch when that situation is detected ?

  Thank you

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  July 16, 2015 at 8:11 am

  #1812972

  allarmi (7/16/2015)

  ---

  Hello,

  is there any way to have sqlserver to terminate the current batch when that situation is detected ?

  Thank you

  Terminate = roll back? Or what, exactly?

  SET XACT_ABORT ON

  may be of interest to you.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel