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