How to add a transactional anonymous subscription (Transact-SQL)

To add an anonymous subscription (transactional)

1. Execute sp_addpublication with allow_pull, allow_anonymous, and immediate_sync set to true to enable anonymous subscriptions.
2. Execute sp_addpullsubscription to create the anonymous subscription at the Subscriber.
3. Execute sp_addpullsubscription_agent to create a scheduled job for the Distribution Agent at the Subscriber.

See Also