How to View or Modify Pull or Anonymous Subscriptions (Transact-SQL)

How to View or Modify Pull or Anonymous Subscriptions (Transact-SQL)

To view pull and anonymous subscription properties for a snapshot publication

1. Execute sp_helpsubscription to list subscription information associated with a particular publication, article, Subscriber, or set of subscriptions.
   
   
2. Execute sp_helppullsubscription to display information about one or more subscriptions at the Subscriber.
   
   
3. Execute sp_helpsubscriberinfo to display information about the Subscriber.

To modify pull and anonymous subscription properties for a snapshot publication

1. Execute sp_changesubscriber to change Subscriber options.
   
   
2. Execute sp_changesubstatus to change Subscriber status.

To view pull and anonymous subscription properties (transactional)

1. Execute sp_helpsubscription to list subscription information associated with a particular publication, article, Subscriber, or set of subscriptions.
   
   
2. Execute sp_helppullsubscription to display information about one or more subscriptions at the Subscriber.
   
   
3. Execute sp_helpsubscriberinfo to display information about the Subscriber.

To modify pull and anonymous subscription properties (transactional)

1. Execute sp_changesubscriber to change Subscriber options.
   
   
2. Execute sp_changesubstatus to change Subscriber status.

To view pull and anonymous subscription properties (merge)

• Execute sp_helpmergepullsubscription to list subscription information associated with a particular publication, article, Subscriber, or set of subscriptions.

To modify pull and anonymous subscription properties (merge)

• Execute sp_changemergepullsubscription to change Subscriber options.