SQL statement to view the transaction log of the SQL Server database

From: http://www.cnblogs.com/Ammy/archive/2008/05/09/1190081.html

1) Use System Functions

Select * From fn_dblog (null, null)

2) use DBCC

DBCC log (dbname, 4) -- (n = 0, 1, 2, 3, 4)

1-more information plus flags, tags, row length

2-detailed information: plus Object Name, index name, page ID, slot ID

3-all information about each operation

4-Add the hexadecimal information of the transaction to all information of each operation.

Default type = 0

To view the transaction log of the msater database, run the following command:

DBCC log (master)

DBCC log ({dbid | dbname}, [, type = {0 | 1 | 2 | 3 | 4}])
Parameters:
Dbid or dbname-ID or name of any database

Type-type of the output result:
0-minimum information (operation, context, transaction ID)
1-more information (plus flags, tags, row length)
2-very detailed information (plus Object Name, index name, page ID, slot ID)

3-all information about each operation
4-Add the hexadecimal information of the transaction to all information of each operation.
Default type = 0