Updatable Subscriptions

By default, data replicated via snapshot replication is not updatable at the subscriber—that is, you can't make changes at the subscriber and have them propagate to the publisher or to other subscribers. However, you can enable a snapshot publication such that it is updatable at the subscriber. You have three options for doing so: immediate updating subscribers, queued updating subscribers, and immediate updating subscribers with queued updating as a fallback.

Immediate Updating

Immediate updating subscribers work by initiating a distributed transaction with the publisher using Microsoft Distributed Transaction Coordinator. The update is carried out using the two-phase commit (2PC) protocol—either the change occurs on ...

Get Guru's Guide to SQL Server Architecture and Internals, The now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.