|
|
|
|
|
Log Explorer 1.2.1 1 2 3 4 5 6 7 8 9 10 Highlighting a row and right mouse clicking gains you access to all of the operations that you would want to perform. You can bookmark an area of the log to allow you to quickly navigate between entries that you are interested in. The three main features in Log Explorer are: Undo, Rollback, and Revision History. These are covered in detail in the next few pages.
Taking the entry that I have highlighted and selecting Revision History displays the screen below. Due to the number of transactions that I've processed, this screen is rather unassuming. What the Row Revision History will do is display all changes made to a given row of data. For example is you had made 50 changes to the authors table against the author ID of 1, then 50 entries will appear in the Row Revision History. This gives you an unprecedented audit trail that you can only obtain by generating a lot of trigger code yourself. Additionally, if you want to roll the changes back to a particular version, then you simply highlight that entry and select the Rollback button.
Selecting the Row ID tab will display the query page for the Row Revision History. This allows you to select a table, a specific data value for a column, and a start date/time to display from.
|
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
