Export (0) Print
Expand All

How to Modify a Push Subscription (Transact-SQL)

SQL Server 2000

How to Modify a Push Subscription (Transact-SQL)

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

To modify push subscription properties for a snapshot publication

  1. Execute sp_changesubscriber to change Subscriber options.

  2. Execute sp_changesubstatus to change Subscriber status.

To view push subscription properties for a transactional publication

  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 Subscriberexecute.

To modify push subscription properties for a transactional publication

  1. Execute sp_changesubscriber to change Subscriber options.

  2. Execute sp_changesubstatus to change Subscriber status.

To view push subscription properties for a merge publication

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

To modify push subscription properties for a merge publication

  • Execute sp_changemergesubscription to change Subscriber options.
Show:
© 2014 Microsoft