How to create a transactional push subscription (Transact-SQL)

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.

See Also