Is there any way you can find out which transactions were rolled back?
No, there is no way find out which transactions were rolled back using Spotlight.
However, Spotlight will show deadlock info on the two processes. It will show the one that suceeded and one that was the victim.
We also have our Toad and LiteSpeed products that have a Log Reader feature that will allow you to undo any transactions in the database.
