I have a question. I've got a replication publication that does not replicate updates on subscriber. Most of inserts are going through fine, I didn't try to delete, because this is prod data. Here is what I know about it so far
1. Properties indicate that this publication is supposed to publish inserts, updates, and deletes
2. There are no errors in the output of sp_helpsubscirptionerrors
3. When running a Validate Subscription it tells me that some of the tables are out of sync based on row count.
I can't find a way to track down the error. Could someone suggest something please. I am going to fix this by initializing snapshot for the tables out of sync, but I would really love to get to the bottom of the issue.