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;

__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)