Open Transaction details

  • SQL_Hunt


    Points: 33264

    Comments posted to this topic are about the item Open Transaction details


  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Hey, this is pretty cool. It works great.

  • muhammadm

    SSC Enthusiast

    Points: 188

    I ran on SSMS and it says command successfully completed

    What this "open transaction details" does?

  • SQL Guy 1


    Points: 15726

    You can do it without cursor

    select session_id,DB_NAME(database_id),text, transaction_id

    from sys.dm_exec_requests r outer apply sys.dm_exec_sql_text (sql_handle)

    where open_transaction_count>1

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

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