Periodically when working in ToadSS the following dialog box pops up.
“You have had an open transaction for a long period. This could keep
others from accessing the database because you might be holding locks.
How would you like to continue?”
I have just confirmed that this dialog appears even when there is no
open transaction, in this case the only query I have run is a select
statement. Additionally, when I have multiple tabs open that I have been
doing work in, there is no indication of which session contains the open
transaction, so I can’t really make an intelligent decision of whether I
want to commit or rollback. As I mentioned earlier, most times I’m not
even aware that there is a pending transaction anywhere.
Is there any chance that this feature can be improved in the next