SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Harsha Majety / Check status of active transactions / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 10:57:14 GMT20RE: Check status of active transactionshttp://www.sqlservercentral.com/Forums/Topic1153965-2846-1.aspxworking on your posted query and works fine . Just one que is that in IsUserTransaction column whats mean for user transaction ? 0 or 1?Fri, 16 Dec 2011 10:11:29 GMTlogicinside22RE: Check status of active transactionshttp://www.sqlservercentral.com/Forums/Topic1153965-2846-1.aspxJust right. Thanks as lot.Maybe also to add [code="other"]USE masterGO[/code]first, as your current database might not be in the required compatibility mode ;-)-RegardsFlemming HansenFri, 05 Aug 2011 00:20:33 GMTfthRE: Check status of active transactionshttp://www.sqlservercentral.com/Forums/Topic1153965-2846-1.aspxThere is a incorrect join condition on the first join as follows;[code="sql"]JOIN sys.dm_tran_session_transactions [tst] ON tat.transaction_id = tat.transaction_id[/code]That should be tat.transaction_id = [b]tst[/b].transaction_idHope this helps.Thu, 04 Aug 2011 11:39:48 GMTDavid BenoitRE: Check status of active transactionshttp://www.sqlservercentral.com/Forums/Topic1153965-2846-1.aspxMsg 102, Level 15, State 1, Line 33Incorrect syntax near 'dec'.:hehe:Thu, 04 Aug 2011 00:16:33 GMTfthCheck status of active transactionshttp://www.sqlservercentral.com/Forums/Topic1153965-2846-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/status/75129/">Check status of active transactions</A>[/B]Wed, 03 Aug 2011 20:33:38 GMTharsha.majety