Getting Information About Distributed Transactions

systransactions stores information about all server transactions, and identifies each transaction and maintains information about the state of the transaction and its associated threads.

sp_transactions translates information from the systransactions and syscoordinations tables to display status conditions for active transactions.