How to Create a Push Subscription (Transact-SQL)

How to Create a Push Subscription (Transact-SQL)

To add a push subscription for a snapshot publication (Transact-SQL)

1. Execute sp_addsubscriber to register the Subscriber at the Publisher.
   
   
2. Execute sp_addpublication with allow_push set to TRUE to enable push subscriptions.
   
   
3. Execute sp_addsubscription to create the subscription.

To create a push subscription (transactional)

1. Execute sp_addsubscriber to register the Subscriber at the Publisher.
   
   
2. Execute sp_addpublication with allow_push set to true to enable push subscriptions.
   
   
3. Execute sp_addsubscription to create the subscription.

To add a push subscription (merge)

1. Execute sp_addsubscriber to register the Subscriber at the Publisher.
   
   
2. Execute sp_addmergepublication with allow_push set to true to enable push subscriptions.
   
   
3. Execute sp_addmergesubscription to create the subscription.