ApexSQL Log is a powerful SQL database auditing tool that analyzes SQL Server's own Transaction Log to display information on data and soon ... structural changes.
Apex SQL Log is a program which passively audit using transaction log backups or live log files. Since ApexSQL Log reads the Transaction Log, no database overhead is required and audits can be done on changes made even before the tool was installed.
Here are some key features of "Apex SQL Log":
· Analyze Transaction log backups. Read not just the online log or detached LDFs but transaction log backups too
· Find all operations within a transaction. Selectively view, undo, or redo one or all operations in a transaction
· Smart Resource Detection. Application can automatically identify the most optimal resource to use for transaction log reading for better speed and performance
· Repeatable sessions through Projects. Save your data source and filter selections to a project for quicker execution in future sessions
· Multiple Report/Output Formats. Display the transaction log information to an HTML report or export to CSV, XML, or SQL Table Format
· Quick Access. All frequently used commands are easily accessible via the Ribbon and the Quick Access toolbar and button
· Copy row to clipboard. Copy one or more rows in the result set to files like text and Excel
· Search the results. Find any value from any field in the transaction log
· Advanced Filtering. Display only what's important to you using ApexSQL Log's advanced filtering feature. Transactions can be pre-filtered to display only the transactions that meet the criteria that you specify
· View Row History. View all modifications to a specific row
· Operation & Transaction Information. Granular details are available for every operation and transaction that's read from the transaction log
· Filter Converter. Easily convert saved filter settings from older versions of ApexSQL Log for use in ApexSQL Log 2010.
Requirements:
· MDAC 2.8(ADO 2.8) MSSQL Server 7, 2000 or 2005,
· .NET Framework 2.0
Limitations:
· 14 days free trial
What's New in This Release: [ read full changelog ]
· The "Check prerequisites on target server" error is encountered when attempting to connect to a SQL Server installed on a system with Data Execution Prevention (DEP) turned on, or on a system that’s had its hardware ID changed