Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

How to: Enable Updating Subscriptions for Transactional Publications (SQL Server Management Studio)


This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Enable updating subscriptions for transactional publications on the Publication Type page of the New Publication Wizard. For more information about using this wizard, see How to: Create a Publication and Define Articles (SQL Server Management Studio). You cannot enable updating subscriptions after a publication is created.

To use updating subscriptions, you must also configure options in the New Subscription Wizard. For more information, see How to: Create an Updatable Subscription to a Transactional Publication (SQL Server Management Studio).

To enable updating subscriptions

  1. On the Publication Type page of the New Publication Wizard, select Transactional publication with updatable subscriptions.

  2. On the Agent Security page, specify security settings for the Queue Reader Agent in addition to the Snapshot Agent and Log Reader Agent. For more information about the permissions required for the account under which the Queue Reader Agent runs, see Replication Agent Security Model.


    The Queue Reader Agent is configured even if you use only immediate updating subscriptions.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft