Adaptive Server has system table, master.dbo.systransactions, which stores information about all server transactions. systransactions identifies each transaction and maintains information about the state of the transaction and its associated threads.
The new system procedure, sp_transactions, translates information from the systransactions and syscoordinations tables to display status conditions for active transactions.