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.