Open Transaction details

  • SQL_Hunt

    SSC-Dedicated

    Points: 33264

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

    Thanks.

  • 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

    SSCoach

    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