http://www2.sqlblog.com/blogs/adam_machanic/archive/tags/transactions/default.aspxTags: transactionsenCommunityServer 2.1 SP2 (Build: 61129.1)http://www2.sqlblog.com/blogs/adam_machanic/archive/2012/06/26/your-transaction-is-in-jeorpardy-and-you-can-t-even-know-it.aspxWed, 27 Jun 2012 01:10:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:44102Adam Machanic7http://www2.sqlblog.com/blogs/adam_machanic/comments/44102.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=44102If you're reading this, please take one minute out of your day and vote for the following Connect item : https://connect.microsoft.com/SQLServer/feedback/details/444030/sys-dm-tran-active-transactions-transaction-state-not-updated-when-an-attention-event-occurs...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2012/06/26/your-transaction-is-in-jeorpardy-and-you-can-t-even-know-it.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=44102" width="1" height="1">DMVsmonitoringtransactions