How to view SQL Server transaction log-http://xu20cn.blog.51cto.com/274020/74126

In SQL Server 7.0 and SQL Server, run the following command:

DBCC log ({dbid | dbname}, [, type = {0 | 1 | 2 | 3 | 4}])

Example: DBCC log (master, 0) 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 of each operation 4-all information of each operation plus hexadecimal information of the transaction default type = 0 ViewRun the following command to view the transaction logs of the msater database:

DBCC log (master)