Open Transaction details

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  September 13, 2015 at 9:23 am

  #307622

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

  Thanks.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  October 1, 2015 at 6:39 am

  #1830722

  Hey, this is pretty cool. It works great.

• muhammadm

  SSC Enthusiast

  Points: 188

  More actions

  October 1, 2015 at 2:21 pm

  #1830905

  I ran on SSMS and it says command successfully completed

  What this "open transaction details" does?

• SQL Guy 1

  SSCoach

  Points: 15979

  More actions

  October 6, 2015 at 7:34 am

  #1831737

  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