Desi adult web cam - Sql 2016 replication immediate updating subscription
Replication is primarily log-based with snapshots on-demand.
This publication includes an article for a table of company data (basic stuff: name, address etc).
If any column that is part of a unique constraint is updated, then SQL Server implements the update as a deferred update, which means as a pair of DELETE/INSERT operations.
This deferred update causes replication to send a pair of DELETE/INSERT statements to the subscribers.
It was brought to our attention this morning that the data in this table was not being updated on the subscriber when changed on the publisher.