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:

  1. Switch to Log Explorer and select the Browse view.
  2. Read any new transactions that have recently appeared in the log by pressing the F5 key or the Refresh button.
  3. Click on the 'Row Revision History' function in the left-hand toolbar
  4. Select the DBO.Service table in the 'Table' drop-down menu
  5. 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'.
  6. Click on the 'View' button near the bottom of the Log Explorer screen

Click 'Next' to continue.