|
|
|
|
|
Log Explorer 2.0 1 2 3 4 5 6 7 8 9 10 11 12 13 The Row Revision History has 2 parts to it. On the first tab, you specify the data values corresponding to the rows you want to see the history for. What the revision history does is show you every changed that has occurred to a particular row of data during the span of transaction logs you are currently viewing.
Clicking the View button will cause Log Explorer to scan the transaction log(s) for all rows in the table specified that match the data values you asked for. It will then display these rows with any revisions that occurred to them. The the case that I ran, I asked for all rows in the authors table where the au_id column was 123-45-6789. This brought up the row I had inserted into the table a while back. Any modifications to that row appear immediately underneath in reverse chronological order.
|
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.
