Post reply

Check status of active transactions

  • August 3, 2011 at 8:33 pm

    #390118

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

  • August 4, 2011 at 12:16 am

    #1363455

    Msg 102, Level 15, State 1, Line 33

    Incorrect syntax near 'dec'.:hehe:

  • August 4, 2011 at 11:39 am

    #1363854

    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

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

  • August 5, 2011 at 12:20 am

    #1364097

    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

  • December 16, 2011 at 10:11 am

    #1422625

    working on your posted query and works fine .

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

  • May 12, 2016 at 7:14 am

    #1878578

    Thanks for the script Harsha.

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

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