How to create a pull subscription (Transact-SQL)

To create a pull subscription (transactional)

1. Execute sp_addpublication with allow_pull set to true to enable pull subscriptions at the Publisher.
2. Execute sp_addsubscriber to register the Subscriber at the Publisher.
3. Execute sp_addsubscription to create the subscription at the Publisher.
4. Execute sp_addpullsubscription to create the pull subscription at the Subscriber.
5. Execute sp_addpullsubscription_agent to create a scheduled job for the Distribution Agent at the Subscriber.

See Also