locked
session RRS feed

  • Question

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

Answers

All replies

  • 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
  • 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
  • HI Abbas,

               Please help me to know abt this Process monitor?

    I amnot aware of it.

    Thursday, September 23, 2010 8:48 AM
  • 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