How To
How to Create a Push Subscription (Transact-SQL)
To add a push subscription for a snapshot publication (Transact-SQL)
- Execute sp_addsubscriber to register the Subscriber at the Publisher.
- Execute sp_addpublication with allow_push set to TRUE to enable push subscriptions.
- Execute sp_addsubscription to create the subscription.
To create a push subscription (transactional)
- Execute sp_addsubscriber to register the Subscriber at the Publisher.
- Execute sp_addpublication with allow_push set to true to enable push subscriptions.
- Execute sp_addsubscription to create the subscription.
To add a push subscription (merge)
- Execute sp_addsubscriber to register the Subscriber at the Publisher.
- Execute sp_addmergepublication with allow_push set to true to enable push subscriptions.
- Execute sp_addmergesubscription to create the subscription.