Return
-
Title
What transactions does the Log Reader support? -
Description
The Log Reader does not show all transactions with the dates I wanted to see.
-
Resolution
The Log Reader supports the following according to the Help | Contents | Index with key words "Log Reader, supported objects."
Support Objects
For SQL Server 2000/2005:
Tables
Check constraints
Primary keys
Foreign keys
Unique constraints
Default constraints
Indexes
Triggers
Views
Defaults
User-defined datatypes
User-defined functions
User-defined procedures
Rules
Statistics
For SQL Server 2005:
DDL triggers
XML indexes
CLR types
Supported DML
For SQL Server 2000/2005:
INSERTs
UPDATEs
DELETEs