Check status of active transactions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Harsha Majety » Check status of active transactions

Check status of active transactions

Rate Topic

Display Mode

Topic Options

Author

Message

harsha.majety

Posted Wednesday, August 03, 2011 8:33 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 17, 2013 1:28 PM
Points: 6, Visits: 396

Comments posted to this topic are about the item Check status of active transactions

Post #1153965

fth

Posted Thursday, August 04, 2011 12:16 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, May 18, 2013 3:23 AM
Points: 8, Visits: 51

Msg 102, Level 15, State 1, Line 33
Incorrect syntax near 'dec'. Hehe

Post #1154013

David Benoit

Posted Thursday, August 04, 2011 11:39 AM

SSCrazy

Group: General Forum Members
Last Login: Saturday, May 18, 2013 8:26 AM
Points: 2,063, Visits: 3,440

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

fth

Posted Friday, August 05, 2011 12:20 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, May 18, 2013 3:23 AM
Points: 8, Visits: 51

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 Wink

-
Regards
Flemming Hansen

Post #1154763

logicinside22

Posted Friday, December 16, 2011 10:11 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 12:27 PM
Points: 280, Visits: 1,027

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 »

Permissions