How to view or modify snapshot push subscription properties (Transact-SQL)

To view push 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_helpsubscriberinfo to display information about a Subscriber.

To modify push subscription properties (snapshot)

  1. Execute sp_changesubscriber to change Subscriber options.
  2. Execute sp_changesubstatus to change Subscriber status.
See Also
Viewing or Modifying Push Subscription Properties sp_helpsubscriberinfo
sp_changesubscriber sp_helpsubscription
sp_changesubstatus  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.