With the Log Reader, you can view the following transaction types:
Full database log (includes all transactions stored in the transaction log of an active database as well as transactions held in SQL Server memory).
Generate T-SQL statements to undo or redo a DML/DDL SQL statement executed on the database. You can then apply the undo or redo statement using the Undo/Redo wizard. For more information, see DML/DDL Page.
Recreate a table in the database and reload data that, as recorded in the transaction log, was dropped or truncated. For more information, see Recover Tables.