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.