Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

Immediate Updating Subscribers

An immediate updating subscriber allows the subscriber to directly modify the published database. When a publication is created, the creator has the option of allowing a subscriber to update the copy of its local data. The updates the subscriber makes will be propagated back to the publisher, and then to the remaining subscribers of the data. The two-phase commit protocol provides assurance that the publisher has received the data and there are no conflicts. If the publisher is unable to receive the data, the transaction made by the subscriber will not be committed on the subscriber's database. The following components are used when immediate updating subscribers is enabled:

• Triggers

• Stored procedures

• Microsoft Distributed ...