SQL Server 2 ways to view the running transaction information.

Method 1, Sys.dm_tran_session_transactions;

Method 2, DBCC OPENTRAN

--------------------------------------------------------------------------------------------------------------- ---------------------------------------------

Method 1,

Sys.dm_tran_session_transactions

SELECT * from Sys.dm_tran_session_transactions;
Go

Print out the activity's transactions.

Method 2,

DBCC OPENTRAN

DBCC OPENTRAN

Summarize:

From the results can be seen,

Sys.dm_tran_session_transactions all current active transactions.

DBCC OPENTRAN returns the oldest (first-started) transaction.

SQL Server 2 ways to view the running transaction information.