How to view or modify snapshot pull and anonymous subscription properties (Transact-SQL)

To view pull and anonymous subscription properties (snapshot)

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 (snapshot)

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

See Also