How to switch from immediate updating to queued updating as a failover (Enterprise Manager)

How to Install SQL Server 2000

How To

How to switch from immediate updating to queued updating as a failover (Enterprise Manager)

  1. For push subscriptions: expand the Replication and Subscriptions directories, right-click the subscription, click Set Update Method, and then select either Immediate Updating or Queued Updating.

  2. For pull subscriptions: on the Subscriber, expand the Pull Subscriptions directory, right-click the subscription, click Properties, and then on the Synchronization tab, select either Immediate Updating or Queued Updating.