February 14, 2014 at 10:50 pm
Hi,
I am getting following error while executing stored procedure.
kindly provide solution.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
February 15, 2014 at 4:13 am
It means you have more than one BEGIN statement and only one COMMIT or END statements. You need to have matching pairs for the query to work correctly.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 16, 2014 at 9:05 pm
Hi,
Thank you for your suggestion.
I got my solution.
February 17, 2014 at 3:49 am
And for anyone who searches up your question in the future and wants to know how you solved it, what was it?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply