Overview::Features::Screenshots::Download::Ordering::Contact

MMC Interface
Users administer a HindSight 2005 server with a console based on the familiar MMC snap-in interface. The system can be accessed as a standalone snap-in using the HindSight 2005 Console or as an extension to SQL Server Enterprise Manager.
Schema Verification
If the schema of the original databases changes after installation, the system can automatically detect and update the schema of the corresponding history databases.
Metrics
HindSight 2005 provides aggregate information showing the total number of inserts, deletes, and updates recorded in the history system. In addition, the system displays comparisons of the size of the original tables and databases to their matching history objects.
Purging
A periodic deletion of historical records can be configured in order to preserve disk space. The purge can be set to occur based on record age or record count.
Granular Configuration
The HindSight 2005 Console allows broad flexibility with respect to configuring history settings. Since all database events may not need to be preserved, the system allows databases, tables, and even individual fields to be enabled or disabled for history at any time.
Custom User Identification
By default, HindSight 2005 records the name of the SQL Server user responsible for any insert, delete, or update event. Alternatively, HindSight 2005 can save the name of the application user. Simply configure your application to run HindSight's [hs_setuser] stored procedure upon connecting to the database.
Intelligent Update Detection
Updates that affect a field are only recorded if the actual data in that field has changed. This feature prevents unnecessary historical records from being created if, for example, a routine constantly resets a flag on all records in a table.
Null Detection
When history has been enabled, updates that change a nullable field from a null to a non-null value, or vice versa, are recorded.
Rollback
The system provides users the ability to return a table, database, or even an entire server to its state at a particular date and time. HindSight 2005 effectively offers an "undo" feature for database operations that occurred after a point in time.
Get Started at No Cost
You can download and use HindSight 2005 free of charge. While in trial mode, all the features listed above will be available, but you will be prevented from enabling history on more than three tables per database.