Post reply

Transaction details

  • August 6, 2010 at 12:11 am

    #238630

    Hi,

    Is there any way to find out details of particular transaction. We can check current transaction ID in SQL 2005, but can we check the whole details of transaction ? Like who is the owner of transaction, database, complete T-SQL of that transaction without using tracing or auditing ?

    Thanks in advance:)

  • August 6, 2010 at 2:38 am

    #1203300

    beejug1983 (8/6/2010)

    Hi,

    Is there any way to find out details of particular transaction. We can check current transaction ID in SQL 2005, but can we check the whole details of transaction ? Like who is the owner of transaction, database, complete T-SQL of that transaction without using tracing or auditing ?

    Thanks in advance:)

    you can use sys.sysprocesses to get a lot of that information.

    you can use dbcc inputbuffer to get the t-sql statement. There are also various DMV's you can use to get similar information

  • August 6, 2010 at 4:59 am

    #1203385

    You can use some of the 3rd party tool to indentify the transaction details.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • August 6, 2010 at 6:35 am

    #1203447

    Dynamic Management Views (DMV) to the rescue!

    Look up in BOL sys.dm_tran_*. You'll find more information than you can shake a stick at. You can combine this with other DMVs like sys.dm_exec_requests or sys.dm_exec_sql_text or sys.dm_exec_query_plan, to put together just about any information you might want about ongoing transactions.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 4 posts - 1 through 3 (of 3 total)

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