How To
How to Create an Anonymous Subscription (Transact-SQL)
To add an anonymous subscription to a snapshot publication (Transact-SQL)
- Execute sp_addpublication with allow_pull, allow_anonymous, and immediate_sync set to TRUE to enable anonymous subscriptions.
- Execute sp_addpullsubscription to create the anonymous subscription at the Subscriber.
- Execute sp_addpullsubscription_agent to create a scheduled job for the Distribution Agent at the Subscriber.
To add an anonymous subscription (transactional)
- Execute sp_addpublication with allow_pull, allow_anonymous, and immediate_sync set to TRUE to enable anonymous subscriptions.
- Execute sp_addpullsubscription to create the anonymous subscription at the Subscriber.
- Execute sp_addpullsubscription_agent to create a scheduled job for the Distribution Agent at the Subscriber.
To add an anonymous subscription to a merge publication
- Execute sp_addmergepublication with allow_pull and allow_anonymous set to TRUE to enable anonymous subscriptions at the Publisher.
- Execute sp_addmergepullsubscription to create the anonymous subscription at the Subscriber.
- Execute sp_addmergepullsubscription_agent to create a scheduled job for the anonymous Merge Agent at the Subscriber.