sp_helpmergesubscription (T-SQL)

Returns information about a push subscription.

Syntax

sp_helpmergesubscription [[@publication =] 'publication']
    [,[@subscriber =] 'subscriber'] [,[@subscriber_db =] 'subscriber_db']
    [,[@publisher =] 'publisher'] [,[@publisher_db =] 'publisher_db']
    [,[@subscription_type =] 'subscription_type']

Arguments

[@publication =] 'publication'

Is the name of the publication. publication is sysname, with a default of %. The publication must already exist and conform to the rules for identifiers. If NULL or %, information about all merge publications and subscriptions in the current database is returned.

[@subscriber =] 'subscriber'

Is the name of the Subscriber. subscriber is sysname, with a default of %. If NULL or %, information about all subscriptions to the given publication is returned.

[@subscriber_db =] 'subscriber_db'

Is the name of the subscription database. subscriber_db is sysname, with a default of %, which returns information about all subscription databases.

[@publisher =] 'publisher'

Is the name of the Publisher. The Publisher must be a valid server. publisher is sysname, with a default of %, which returns information about all Publishers.

[@publisher_db =] 'publisher_db'

Is the name of the Publisher database. publisher_db is sysname, with a default of %, which returns information about all Publisher databases.

[@subscription_type =] 'subscription_type'

Is the type of subscription. subscription_type is nvarchar(15), and can be one of these values.

Value	Description
push (default)	Push subscription
pull	Pull subscription
both	Both a push and pull subscription

Result Sets

Column name	Data type	Description
publication	sysname	Name of the publication
publisher	sysname	Name of the Publisher
publisher_db	sysname	Name of the Publisher database
subscriber	sysname	Name of the Subscriber
subscriber_db	sysname	Name of the subscription database
status	int	Status of the subscription
subscriber_type	int	Type of Subscriber
subscription_type	int	Type of subscription: 0 = Push 1 = Pull 2 = Both
priority	float(8)	Number indicating the priority for the subscription
sync_type	tinyint	Subscription sync type
description	nvarchar(255)	Brief description of this merge subscription
merge_jobid	binary(16)	Job ID of the Merge Agent
full_publication	tinyint	Whether the subscription is to a full or filtered publication

Remarks

sp_helpmergesubscription is used in merge replication.

Permissions

Execute permissions default to the public role.

sp_addmergesubscription	sp_dropmergesubscription
sp_changemergesubscription	System Stored Procedures