locked
session RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    How to see a open transaction in a session?
    Thursday, September 23, 2010 3:32 AM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    check 

    check this query.... if u didn't get info. check those 2 tables..

    select * from sys.dm_tran_active_transactions T
inner join sys.dm_tran_session_transactions S on T.transaction_id = S.transaction_id
where S.session_id = @@SPID and T.transaction_state <= 2

     

     

    • Proposed as answer by Muhammad Abbas Thursday, September 23, 2010 5:41 AM
    Thursday, September 23, 2010 3:43 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    you can also see it trough process monitor
    • Proposed as answer by Muhammad Abbas Thursday, September 23, 2010 5:41 AM
    Thursday, September 23, 2010 5:41 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    HI Abbas,

               Please help me to know abt this Process monitor?

    I amnot aware of it.

    Thursday, September 23, 2010 8:48 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    See if this blog may be helpful 

    Activity Monitor to gather statistics and health of SQL Server 2008

    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Marked as answer by Ai-hua Qiu Friday, October 1, 2010 9:12 AM
    Sunday, September 26, 2010 3:10 AM