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

To view push subscription properties (transactional)

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

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

See Also