Looking at the operation log in SQL Server has always been a hassle, because Microsoft has not provided direct system tools to view the log content, although it is possible to get the non-parsed encoding of the log through the unofficial hidden interface DBCC log but it is a very troublesome thing to restore. </DIV> <DIV> in the era of SQL Server 2000 to 2005, SQL Server database content could be obtained through Logexplor, but after the 2008 database, it was found that Logexplor company no longer developed a subsequent version. Search the following on the Internet at night, found a very good tool apexsql Log. The latest version is version 2008.06, which provides support for the SQL SERVER2008R2 version. Unfortunately I get is trial version, did not find cracked key. Hey
; He provides row information for the table structure, Operation history
; Undo Script
, Redo script,
Transaction details (such as client name, login name, type of operation, operation time, etc.)
Querying SQL Server database logging tools