Doing the Detective Work
With Log Explorer, you can quickly locate the transaction responsible for changing
Mr. Jordan's record.
One of the powerful capabilities Log Explorer offers is the ability to view
the history of changes made to a record in the database. Let's use the "Row
Revision" function to locate the problem:
- Switch to Log Explorer and select the Browse view.
- Read any new transactions that have recently appeared in the log by
pressing the F5 key or the Refresh button.

- Click on the 'Row Revision History' function in the left-hand toolbar
- Select the DBO.Service table in the 'Table' drop-down menu
- Identify the row in question by customer ID. In this case, we remember that
Michael Jordan's ID is #23, so enter 23 in the 'Column Value' field for 'CustID'.
- Click on the 'View' button near the bottom of the Log Explorer screen
Click 'Next' to continue.