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


© Copyright SS64.com 1999-2014
Some rights reserved