Home Dashboard Directory Help
Search

SMO: ServerConnection.CommitTransaction() Method by DanMaxic


Status: 

Active


2
0
Sign in
to vote
Type: Bug
ID: 776674
Opened: 1/15/2013 11:41:27 PM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

SMO: ServerConnection.CommitTransaction() Method.
CommitTransaction() excecute the follwing t-sql code: if (@@trancount > 0) COMMIT TRANSACTION
So if from the code you are tring to commit transaction that is not open it will not be failed,
It sould rair error message 3902: The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.

Details
Sign in to post a comment.
Posted by Microsoft on 3/28/2013 at 5:52 PM
Hello

We took a look at this DCR along with several others. Unfortunately triaging it against other critical DCRs I do not think we would get to investigate and implement this in the near future, so we decided not to proceed with this DCR in the next SQL Server release.

However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this implemented.

Thanks for writing to Microsoft.
Alex Grach (MSFT)
Posted by Microsoft on 1/29/2013 at 2:00 PM
Thank you for reporting this issue - we are investigating and will update you when we have more information.

Thanks,

Alex Grach [MSFT SQL SERVER]
Sign in to post a workaround.