Comments posted to this topic are about the item Open Transaction details
Hey, this is pretty cool. It works great.
I ran on SSMS and it says command successfully completed
What this "open transaction details" does?
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)
Viewing 4 posts - 1 through 3 (of 3 total)