Wednesday, June 13, 2012 1:13 PM
we have seen an issue in replication of one article and business decided that we no longer needs this table for replication .
So we want to skip all the existing transactions of this article using a script and then drop this article from publication.
Do anyone have a script which can identify all the breaking transactions of the article , skip it and then we can drop that article
Thursday, June 14, 2012 2:48 AMModerator
We can skip errors in Transactional Replication using the Distribution Agent -SkipErrors parameter or by using the Distribution Agent profile Continue on Data Consistency Errors.