Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Check status of active transactions Expand / Collapse
Author
Message
Posted Wednesday, August 3, 2011 8:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 16, 2014 2:48 PM
Points: 9, Visits: 435
Comments posted to this topic are about the item Check status of active transactions
Post #1153965
Posted Thursday, August 4, 2011 12:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 6:13 AM
Points: 10, Visits: 72
Msg 102, Level 15, State 1, Line 33
Incorrect syntax near 'dec'.
Post #1154013
Posted Thursday, August 4, 2011 11:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:09 AM
Points: 2,049, Visits: 3,585
There is a incorrect join condition on the first join as follows;

JOIN sys.dm_tran_session_transactions [tst]
ON tat.transaction_id = tat.transaction_id

That should be tat.transaction_id = tst.transaction_id

Hope this helps.


David

@SQLTentmaker
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Post #1154471
Posted Friday, August 5, 2011 12:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 6:13 AM
Points: 10, Visits: 72
Just right. Thanks as lot.

Maybe also to add

USE master
GO

first, as your current database might not be in the required compatibility mode


-
Regards
Flemming Hansen
Post #1154763
Posted Friday, December 16, 2011 10:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:13 PM
Points: 321, Visits: 1,285
working on your posted query and works fine .
Just one que is that in IsUserTransaction column whats mean for user transaction ? 0 or 1?


Aim to inspire rather than to teach.
SQL Server DBA
Post #1223224
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse