Creating, Modifying, and Deleting Subscriptions (Replication)
TOC
Collapse the table of content
Expand the table of content

Creating, Modifying, and Deleting Subscriptions (Replication)

SQL Server 2008 R2

You can create, modify, and delete subscriptions using SQL Server Management Studio, replication stored procedures, and Replication Management Objects (RMO). In the case of RMO and stored procedures, the classes and procedures that you use depend on both the type of publication to which the subscription belongs (transactional and snapshot or merge) and the server on which the synchronization agent for the subscription runs. For pull subscriptions, the synchronization agent runs at the Subscriber, and for push subscriptions, the synchronization agent runs at the Distributor.

The following topics describe how to create, work with, and delete subscriptions.

Community Additions

ADD
Show:
© 2016 Microsoft