Table Level Journaled Transactions
On the table level, the right pane looks and functions similar to the one at the database level, but only the row changes corresponding to the selected table appear. There is no Group by Transaction check box for the table level. At the table level, you can view a history of journaled changes in that table.
As opposed to the database level panes, where more than one table was involved, it is possible here to have the real column names become headers of the results list, which was not possible at the database level because the columns are normally different in each table that was involved in the transaction.
You can also sort the data on the table level by clicking on a column header. In particular, the following sorts are useful:
• Commit date—this is the most meaningful criteria for sorting the changes
• Transaction number—be aware that the transactions are not always committed in the same order
• LSN—shows you the exact sequence of row changes
For more information on the interface for this utility, see the Journal Analyzer online help topics.
Last modified date: 08/28/2024