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.

• Transaction Identification in systransactions
  SAP ASE stores transaction names in a column of varchar(255) to accommodate the length and format of transaction names supplied by different distributed transaction protocols.
• Viewing active transactions with sp_transactions
  The sp_transactions procedure translates information from systransactions and syscoordinations to provide information about active transactions.
• Determining the Commit Node and gtrid with sp_transactions
  Using sp_transactions with the xid keyword displays the commit node, parent node, and gtrid of a particular transaction, and all active transactions.