sp_helpmergepullsubscription (T-SQL)

Returns information about the pull subscription.

Syntax

sp_helpmergepullsubscription [[@publication =] 'publication']
[,[@publisher =] 'publisher'] [,[@publisher_db =] 'publisher_db']
[,[@subscription_type =] 'subscription_type']

Argument

[@publication =] 'publication': Is the name of the publication. publication is sysname, with a default of %. If publication is %, information about all merge publications and subscriptions in the current database is returned.
[@publisher =] 'publisher': Is the name of the Publisher. publisher is sysname, with a default of %.
[@publisher_db =] 'publisher_db': Is the name of the Publisher database. publisher_db is sysname, with a default of %.
[@subscription_type =] 'subscription_type': Is whether to show pull subscriptions. subscription_type is nvarchar(10), with a default of pull.

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
subscription _db	sysname	Name of the subscription database
status	int	Subscription status
subscriber_type	int	Type of Subscriber: 1 = Global 2 = Local 3 = Anonymous
subscription_type	int	Type of subscription: 0 = Push 1 = Pull 2 = Anonymous
priority	float(8)	Subscription priority. The value must be less than 100.00.
sync_type	tinyint	Subscription sync type: 1 = Automatic 2 = Nosync
description	nvarchar(255)	Brief description of this pull subscription
merge_jobid	binary(16)	Job ID of the Merge Agent
enabled_for_synmgr	int	Whether the subscription can be synchronized through the Microsoft Synchronization Manager.

Note that the result set is identical to that of sp_helpmergesubscription.

Remarks

sp_helpmergepullsubscription is used in merge replication.

Permissions

Execute permissions default to the public role.