DBCC View Log

1. DBCC Loginfo

2. DBCC Sqlperf (LOGSPACE)

Show Log space usage

2. DBCC LOG (<database name>[,{0|1|2|3|4}])

0-basic Log Information (default)
1-lengthy Info
2-very Length Info
3-detailed
4-full

EXAMPLE:DBCC log (my_db, 4)

And it displays the following transaction log information:
Current LSN
Operation (string starts with lop_xxxxx)
Context (string starts with lcx_xxxx)
Transaction ID
Tag Bits (Hex)
Log record Fixed Length (int)
Log record Length (int)
Previous LSN
Flag Bits (Hex)
Description (String)
Log Record (HEX)