Problem to debug stored procedure

Question

There is a SP which gets over 96 items as parameters. I want to debug this sp, how can I do it?

It says:

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

Please tell me a way to find this error? I will give more details the more answers come..

abatishchev · Accepted Answer · 2010-10-20 15:25:25Z

3

This SP will run properly:

BEGIN TRAN
...
COMMIT

But this:

BEGIN TRAN
...

or this:

...
COMMIT

will not!

answered Oct 20, 2010 at 15:25

abatishchev

101k88 gold badges303 silver badges443 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fosco · Accepted Answer · 2010-10-20 15:27:10Z

2

Forget about the number of parameters... start going through the code and counting the BEGIN entries as a +1 and COMMIT entries as a -1.. when you get to a place where your count is a -1, you found the error. Or, if you get to the end and your count isn't 0, there's your error. Every begin must have one commit.

answered Oct 20, 2010 at 15:27

Fosco

38.6k7 gold badges90 silver badges101 bronze badges

Collectives™ on Stack Overflow

Problem to debug stored procedure

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related