Creating, Modifying, and Deleting Subscriptions (Replication)
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.
In This Section
The following topics describe how to create, work with, and delete subscriptions.
How to: Create a Pull Subscription (SQL Server Management Studio)
How to: Create a Pull Subscription (Replication Transact-SQL Programming)
How to: View and Modify Pull Subscription Properties (SQL Server Management Studio)
How to: View and Modify Pull Subscription Properties (Replication Transact-SQL Programming)
How to: View and Modify Pull Subscription Properties (RMO Programming)
How to: Delete a Pull Subscription (SQL Server Management Studio)
How to: Delete a Pull Subscription (Replication Transact-SQL Programming)
How to: Create a Push Subscription (SQL Server Management Studio)
How to: Create a Push Subscription (Replication Transact-SQL Programming)
How to: View and Modify Push Subscription Properties (SQL Server Management Studio)
How to: View and Modify Push Subscription Properties (Replication Transact-SQL Programming)
How to: View and Modify Push Subscription Properties (RMO Programming)
How to: Delete a Push Subscription (SQL Server Management Studio)
How to: Delete a Push Subscription (Replication Transact-SQL Programming)
How to: Specify Synchronization Schedules (SQL Server Management Studio)
How to: Specify Synchronization Schedules (Replication Transact-SQL Programming)
How to: Create a Subscription for a Non-SQL Server Subscriber (SQL Server Management Studio)
How to: Create a Subscription for a Non-SQL Server Subscriber (Replication Transact-SQL Programming)