The DML/DDL page displays the DML and DDL commands that were executed on the database for the selected log files. The Log Reader can reconstruct these commands from log records, giving you the option to undo or redo individual commands or to roll back an entire transaction.
To view the DML and DDL commands executed in the database
Select the DML/DDL page in the Log Reader window. Log Reader displays the following information about the log entries on this page:
Navigate through and organize the log record entries to help you locate the information you need to review. Use any of these methods:
Tab |
Description |
---|---|
Record Data |
Column name, column type, and values affected by the statement. |
User Info |
Information about the user and application that made the change. Note: The Log Reader can collect NT User, SQL Login, User Host, and Application information for transactions started only when it is connected to the server. |
Undo SQL |
T-SQL to undo the action. |
Redo SQL |
T-SQL to redo the action. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center