How to Create an Anonymous Subscription (Transact-SQL)

How to Install SQL Server 2000

How To

How to Create an Anonymous Subscription (Transact-SQL)

To add an anonymous subscription to a snapshot publication (Transact-SQL)

  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.

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.

To add an anonymous subscription to a merge publication

  1. Execute sp_addmergepublication with allow_pull and allow_anonymous set to TRUE to enable anonymous subscriptions at the Publisher.

  2. Execute sp_addmergepullsubscription to create the anonymous subscription at the Subscriber.

  3. Execute sp_addmergepullsubscription_agent to create a scheduled job for the anonymous Merge Agent at the Subscriber.