dbcc log

Purpose: displays transaction log records.

Usage:

dbcc log (dbid, objid, pageno, rowno, nrecs, type, printopt)

dbid     - database ID
objid    - can be < 0, zero, or > 0. Meaning of this
           option depends on the values of 'pageno'
           and/or 'rowno'. For example, if objid >0 and
           'pageno' and 'rowno' = 0, all records for
           that object are displayed.
pageno   - page number (or 0)
rowno    - row number (or 0)
nrecs    - number of records and log scan direction
type     - the type of log record to display
printopt - denotes display options
           0 - display header and data
           1 - display header only.