If you are a Small Business customer, find additional troubleshooting and learning resources at the Support for Small Business site.

When the Log Reader Agent runs to replicate transactions for a transactional replication in Microsoft SQL Server 2005 or in Microsoft SQL Server 2008, the Log Reader Agent skips some transactions. This problem occurs when the following conditions are true:

A rebuild index command is running against the published database.

The rebuild index command is running in another database context.

For example, this problem occurs when you run the following statements to run the rebuild index command in the context of the master database:

To work around this issue, make sure that you are running the rebuild index command under the context of the published database. For example, run the following statements to run the rebuild index command in the context of the published database:

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in SQL Server 2005 Service Pack 3 for SQL Server 2005. This problem was first corrected in SQL Server 2008 Service Pack 1 for SQL Server 2008.