DBCC OPENTRAN

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)

Example

BEGIN TRAN
...Insert/Update/Delete
GO
DBCC OPENTRAN;
ROLLBACK TRAN;

“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