Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 2. RE: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 2.

  • September 1, 2015 at 6:13 pm

    #1823841

    GilaMonster (9/1/2015)

    Then someone else changed something, or you changed something that you didn't think relevant. CheckDB CANNOT have fixed the error you posted.

    I suspected that someone changed something. I did not tough the code for weeks and all of a sudden it bombed out.

    Thanks.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/