• Roy

    Thank you for the link.

    @publisher='MyPubServer',@publisher_db='MyPubDB',@publication='MyPublication',@subscriber='MySubServer',@subscriber_db='MySubDB' shows the error codes correctly.

    I tried -SkipErrors in the Distribution , Subscription & Publishing agent run for error codes 2621;2627;20053. That does not seem to be helping. I have opened a ticket with MS Support. Will keep you posted once the issue is resolved. I am of the opinion that i missed something obvious. I am yet to try the other option sp_setsubscriptionxactseqno. I prefer to go one at a time since this is only Pre-Production testing.