Home Forums SQL Server 2005 T-SQL (SS2K5) Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. RE: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.

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

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.