February 24, 2009 at 8:17 am
The activated proc [dbo].[xyz] running on queue xyz.table output the following: 'Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 2.'
I'm receiving the above error.
February 24, 2009 at 9:35 pm
You are getting an error after your BEGIN TRANSACTION and before your COMMIT TRANSACTION. This causes control to transfer to your CATCH block, which does not resolve the transaction that you started.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 24, 2009 at 9:54 pm
so wht do i need to do now..do i need to commit or rollback the transaction in the catch block?
February 24, 2009 at 10:29 pm
Deoends on what the error is, where it was in the procedure and what was actually executing at the tinme of the error.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply