sp_helpsubscription Replication Stored Procedure

Lists subscription information associated with a particular publication, article, subscriber, or set of subscriptions.

Syntax

sp_helpsubscription [publication [, article [, subscriber ]]]

where

publication
Is the name of the associated publication. If publication is not given, returns all subscription information for this server.
article
Is the name of the article. If article is not given, returns all subscription information for selected publications and subscribers.
subscriber
Specifies the subscription server that will view subscriptions. If subscriber is not provided, returns all subscription information for selected publications and articles.

Remarks

This stored procedure returns subscriber, publication, article, destination database, subscription status, and synchronization type.

Example

This example returns all subscription information about the publication authors_publication and the article authors.

sp_helpsubscription authors_publication, authors

Permission

Execute permission defaults to the public group.

Tables Used

sysarticles, syspublications, syssubscriptions, sysservers

See Also

sp_addsubscription sp_dropsubscription
sp_changesubscription sp_subscribe
sp_changesubstatus sp_unsubscribe