Tag: CDC

CDC functionality may break after upgrading to the latest CU for SQL Server 2012, 2014 and 2016

This problem was brought to our attention recently by one of our customers. CDC LogScan job fails, possible Error Message: Log Scan process failed in processing log records. Operand type clash: int is incompatible with uniqueidentifier Operand type clash: int is incompatible with datetime The Log-Scan Process failed to construct a replicated command from log
Read More »

Cannot Replicate “Stored Procedure Execution” when CDC is Enabled

Replicate Execution of Stored Procedure and CDC: With Transactional Replication you can replicatethe  execution of the Stored Procedure like this: This has several advantages as discussed in this article: http://msdn.microsoft.com/en-us/library/ms152754.aspx . When you enable Change Data Capture (CDC) at the Database level, replication of the stored procedure execution will NOT work. This is By Design.
Read More »