Visual indication on open transaction
Show a visual indication when open transactions exist in a query window (@@TRANCOUNT > 0)
It could be changing the background color of the query window, and a number in the status bar showing the current transaction depth or something like that.
Michael Eklöf shared this idea
Rubens Farias commented
That would be a wonderful feature!
SSMS Boost has a similar feature. Would be great to see in SQL Prompt
Thorsten Puffer commented
This would be really helpful, we often encounter the situation that we open a Transaction, run some DML statements and then "forget" to commit the transaction. That causes big trouble when you are in a production environment!