Rollback Notification - by Mark Schurmann

Status : 


Sign in
to vote
ID 779516 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 2/19/2013 8:45:06 AM
Access Restriction Public


A very simple change that would save use many hours of chasing our tail is simply to put text in the messaging of a rolled back transaction that it was rolled back.

When executing a transaction to update the database, users will often execute it with a rollback to make sure it does what they want before running it with commit.  The messaging returned by Sql for a committed transaction and a rolled back transaction is identical.  While it seems stupid, often times the user can become distracted and think that the update was commited.  Then when they or another user finds that the change is not there, time is wasted looking for what went wrong.

We've also had cases where a script that is tested in QA has a rollback in it that is forgotten about because the script runs without errors.

I am not saying that a rollback should be considered an error, but the messaging should be different from commit so the user is aware that the change was not commited to the database.
Sign in to post a comment.
Posted by Microsoft on 2/23/2013 at 7:58 AM
Hi Mark - thanks for taking the time to post recommendations on future enhancements to SQL Server product. One challenge with this request is backwards compatibility in that apps/programs are not expecting anything to be returned (text in this case) from the rollback operation. While I don't think there is a definite behavior discribed in the TSQL standard this would be a grey area in terms of compliance and behaviors of current implementations of the standard.

In any case, we'll keep this request in mind as look at changes for future release.

thanks again for taking the time to contact us about improving the product.