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.