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 03, 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 04, 2011 12:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:08 AM
Points: 10, Visits: 66
Msg 102, Level 15, State 1, Line 33
Incorrect syntax near 'dec'.
Post #1154013
Posted Thursday, August 04, 2011 11:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 3:20 PM
Points: 2,105, Visits: 3,560
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 05, 2011 12:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:08 AM
Points: 10, Visits: 66
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: Today @ 1:05 PM
Points: 304, Visits: 1,171
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