O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required