September 13, 2015 at 9:23 am
Comments posted to this topic are about the item Open Transaction details
Thanks.
October 1, 2015 at 6:39 am
Hey, this is pretty cool. It works great.
October 1, 2015 at 2:21 pm
I ran on SSMS and it says command successfully completed
What this "open transaction details" does?
October 6, 2015 at 7:34 am
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply