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)

Examples

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