nadeem avatar image
nadeem asked

Merge Replication, Delete is working at publisher(if a row is deleted at publisher it's getting updated at subscriber) and not working at subscriber(if a row is deleted at subscriber it's not getting deleted at publisher)?

Hi, We've merge replication configured in our environment(Between 4 SQL servers 2008R2). As we know merge replication is bidirectional, its working fine in case of inserts i.e, if a row is inserted at publisher it's getting updated at subscriber and vice-versa. The Issue is, if row gets deleted at publisher its getting deleted at subscriber but, if a row gets deleted in any of 3 subscribers its not getting deleted at publisher. I've checked delete_tracking option in sp_helpmergearticle and its set to '1'. Please help me out. Thank you in advance. Regards, Nadeem
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers