Distrubution agent fails with "Could not find stored procedure XXXXX_msrepl_ccs"

Sateesh Yele  Microsoft SQL Server Escalation Services. Issue:The distribution agent is failing when applying the snapshot so it will retry applying the snapshot again and again. Below is the Distribution agent verbose log that explains the error message and you can see that the distribution agent is retrying the snapshot by scanning the first LSN…

0

Cannot Replicate “Stored Procedure Execution” when CDC is Enabled

Cannot Replicate “Stored Procedure Execution” when CDC is Enabled Taiyebali Zakir | Support Escalation Engineer | MS SQL Server CTS   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…

1

Exploration into “Row was not found”

Exploration into “Row was not found”   Chris Skorlinski Microsoft SQL Server Escalation Services. “The row was not found at the Subscriber when applying the replicated command.” errors reported by the SQL Replication Distribution Agent can often be some of the hardest issues to troubleshoot.  With great satisfaction I was able to uncover this mysterious…

0