Post reply

Transactional Replication

  • April 28, 2017 at 5:08 am

    #324902

    We're having an issue with our transactional replication where inserts are going across, but updates and deletes are not.

    We have them set to replicate, and when we set this up before with the identical scripts, this was all working.

    What can we look at to sort this?

  • May 1, 2017 at 3:17 am

    #1940531

    Hi,

    Please check sysarticles on publisher first (or setting of the given article- via GUI) if there are update and delete replicated. del_cmd and upd_cmd columns should have procedures names (sysarticles table on publisher).

    Are all updates and deletes not coming down? or just some?

    Cheers,
    B

    BartL
    Replication Blog

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply