Creating, Modifying, and Deleting Subscriptions (Replication Transact-SQL Programming)
Replication system stored procedures enable you to create, modify, and delete subscriptions. The stored procedures used 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 detail how to create, work with, and delete subscriptions:
- How to: Create a Pull Subscription (Replication Transact-SQL Programming)
- How to: View and Modify Pull Subscription Properties (Replication Transact-SQL Programming)
- How to: Delete a Pull Subscription (Replication Transact-SQL Programming)
- How to: Create a Push Subscription (Replication Transact-SQL Programming)
- How to: View and Modify Push Subscription Properties (Replication Transact-SQL Programming)
- How to: Delete a Push Subscription (Replication Transact-SQL Programming)
- How to: Create an Updatable Subscription to a Transactional Publication (Replication Transact-SQL Programming)
- How to: Specify Synchronization Schedules (Replication Transact-SQL Programming)
- How to: Specify Interactive Conflict Resolution for Merge Articles (Replication Transact-SQL Programming)
- How to: Create a Subscription for a Non-SQL Server Subscriber (Replication Transact-SQL Programming)
See Also
Concepts
Creating, Modifying, and Deleting Subscriptions (RMO Programming)