Script to skip failed transaction of article
-
Wednesday, June 13, 2012 1:13 PM
Hello All,
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
All Replies
-
Thursday, June 14, 2012 2:48 AMModerator
Hi RajeshSql,
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.
Transactions can also be skipped using sp_helpsubscriptionerrors and sp_setsubscriptionxactseqno.
Skipping Errors in Transactional Replication
How to skip a transaction in SQL 2005/2008 Transactional Replication
- Proposed As Answer by DavidBenoit Thursday, June 14, 2012 1:05 PM
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Sunday, June 24, 2012 2:56 PM

