How to add a snapshot push subscription (Transact-SQL)

To add a push subscription (snapshot)

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.

See Also