Year: 2013

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 »