Display information about the oldest active transaction and the oldest replicated transactions.
Syntax DBCC OPENTRAN
[( [ 'database' | database_id | 0 ] ) ]
[WITH TABLERESULTS] [, [NO_INFOMSGS] ]
] Key: TABLERESULTS - Output in a tabular format that can be loaded into a table. NO_INFOMSGS - Suppress all information messages (severity 0-10)
“If love does not know how to give and take without restrictions, it is not love, but a transaction that never fails to lay stress on a plus and a minus” - Emma Goldman
Equivalent Oracle command:
Select from V$TRANSACTION