How to view or modify snapshot push subscription properties (Transact-SQL)
To view push subscription properties (snapshot)
- Execute sp_helpsubscription to list subscription information associated with a particular publication, article, Subscriber, or set of subscriptions.
- Execute sp_helpsubscriberinfo to display information about a Subscriber.
To modify push subscription properties (snapshot)
- Execute sp_changesubscriber to change Subscriber options.
- Execute sp_changesubstatus to change Subscriber status.
See Also
(c) 1988-98 Microsoft Corporation. All Rights Reserved.