Post reply

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

  • 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

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply