ApexSQL Log is a sophisticated Microsoft SQL Server log auditing tool that analyses the SQL Server's transaction log and displays the details of data changes that include the changes made by the user (nt user) computer and the application from which the change was made. Because ApexSQL Log can read its transaction log, there is no overhead for databases. Database triggers aren't used, and audits are possible concerning changes made before the application was implemented. ApexSQL Log is compatible with every SQL Server version, including 7 2000, 2005, and 2008.
Assistance to SQL Server 2008 New Features
NEW Data Types Fully available in auditing and undoing, and redoing DML operations as well as exporting DDL feature
Date and Time is a tool that simplifies your work using dates and times with a wide range of date options and precision of fractional seconds, along with time zone support. Hierarchy is a way to represent the position of a row in order of hierarchy. It also defines the desired relationships between rows
Spatial is one of the already defined CLR data types that are available in SQL Server that allow you to express details about the physical location and the shape of geometric objects
Audit to identify who was responsible and at what Time.
Read transaction logs online as well as detached logs. even backups of transaction logs
ApexSQL Log can read the following types of transaction log:
Review DDL operations
ApexSQL Log is a tool for DDL command reconstruction and supports all of the DDL commands available for SQL Server 2000.
CREATE/ALTER/DROP TABLE
CREATE/DROP INDEX
CREATE/DROP FUNCTION
CREATE/DROP PROCEDURE
CREATE/DROP TIGGER
CREATE/DROP SEE
GRANT/DENY/REVOKE
EXEC sp_adduser
EXEC sp_dropuser
EXEC sp_rename
View the full audit history
Additional information about the row, including the changed columns or which record was added on the Row Details tab.
The row History tab displays the row history of each change. The row History tab shows more details about the changes that took place, The date on which the change took place as well as the type of operation (Insert the data, Update or Delete) as well as the user who was responsible for the change and so on.
Transactions that rollback or reconfigure
It is easy to roll back or reconstruct deletions, insertions, or even updates. Transactions retrieved from your transaction log may be "undone" or "redone". Select your transaction(s) and click "Create Undo Script' or 'Create Redo Script' from the menu.
Export Audit trail data
Audit trails are easily exported in CSV, SQL, and XML formats.
Scroll down to precisely the logs you wish to look at using the filter wizard
Log Selection Wizard guides you through the procedure of auditing and customizing your audit data through filters.
Schedule and Run Jobs in the dark, without being watched, overnight, etc.
ApexSQL Log offers a powerful console application that allows the tool to be utilized in automated processes that can be executed at night, at a time, and without any supervision or even unsupervised. The majority of GUI operations are performed using the commands line interface. Its Command-Line Interface offers scores of switch options, support for XML argument files, and regular switches such as Test and Help.
