Check status of active transactions

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Flemming_Thor Old Hand Points: 302 More actions · Answer 1

Msg 102, Level 15, State 1, Line 33

Incorrect syntax near 'dec'.:hehe:

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 2

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

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Flemming_Thor Old Hand Points: 302 More actions · Answer 3

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

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 4

working on your posted query and works fine .

Just one que is that in IsUserTransaction column whats mean for user transaction ? 0 or 1?

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 5

SSC Guru

Points: 76202

May 12, 2016 at 7:14 am

Thanks for the script Harsha.