How to fix 'an error occurred while executing the command definition'. See the inner exception for details

ads

InnerException    {"Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0."}    System.Exception {System.Data.SqlClient.SqlException}

What I have tried:

InnerException    {"Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0."}    System.Exception {System.Data.SqlClient.SqlException}

Solution 1
Read the error:

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements

Now look at your SQL code, and manually match up the start and end statements.

We can;t do that for you: we don't have any access to your code... 

ads