Limiting sp_transactions Output to Specific States

Use sp_transactions with the state keyword to limit output to the specified transaction state.

For example, this displays information only for distributed transactions that have been prepared:
sp_transactions "state", "Prepared"
Parent topic: Viewing active transactions with sp_transactions