sp_helpmergepullsubscription

Returns information about the pull subscription. This stored procedure is executed at the Subscriber on the subscription database.

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'. Valid values are 'push', 'pull', or 'both'.

Result Sets

Column name	Data type	Description
subscription_name	nvarchar(1000)	Name of the subscription.
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: 0 = All jobs are waiting to start 1 = One or more jobs are starting 2 = All jobs have successfully executed 3 = At least one job is executing 4 = All jobs are scheduled and idle 5 = At least one job is attempting to execute after a previous failure 6 = At least one job has failed to execute successfully
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 synchronization 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.
last_updated	nvarchar(26)	Date publication was last updated.
publisher_login	sysname	The Publisher login name.
publisher_password	sysname	The Publisher password.
publisher_security_mode	int	Specifies the security mode of the Publisher: 0 = SQL Server Authentication 1 = Windows Authentication
distributor	sysname	Name of the Distributor.
distributor_login	sysname	The Distributor login name.
distributor_password	sysname	The Distributor password.
distributor_security_mode	int	Specifies the security mode of the Distributor: 0 = SQL Server Authentication 1 = Windows Authentication
ftp_address	sysname	Available for backward compatibility only. Is the network address of the FTP service for the Distributor.
ftp_port	int	Available for backward compatibility only. Is the port number of the FTP service for the Distributor.
ftp_login	sysname	Available for backward compatibility only. Is the username used to connect to the FTP service.
ftp_password	sysname	Available for backward compatibility only. Is the user password used to connect to the FTP service.
alt_snapshot_folder	nvarchar(255)	Location where snapshot folder is stored if the location is other than or in addition to the default location.
working_directory	nvarchar(255)	Fully qualified path to the directory where snapshot files are transferred using FTP when that option is specified.
use_ftp	bit	Subscription is subscribing to Publication over the Internet and FTP addressing properties are configured. If 0, Subscription is not using FTP. If 1, subscription is using FTP.
offload_agent	bit	Specifies if the agent can be activated and run remotely. If 0, the agent cannot be remotely activated.
offload_server	sysname	Name of the server  used for remote activation.
use_interactive_resolver		Returns whether or not the interactive resolver is used during reconciliation. If 0, the interactive resolver is not used.
subid	uniqueidentifier	ID of the Subscriber.
dynamic_snapshot_location	nvarchar(255)	The path to the folder where the snapshot files are saved.
last_sync_status	int	Subscription status: 0 = All jobs are waiting to start 1 = One or more jobs are starting 2 = All jobs have executed successfully 3 = At least one job is executing 4 = All jobs are scheduled and idle 5 = At least one job is attempting to execute after a previous failure 6 = At least one job has failed to execute successfully
last_sync_summary	sysname	Description of last synchronization results.

Remarks

sp_helpmergepullsubscription is used in merge replication. In the result set, the date returned in last_updated is formatted as YYYYMMDD hh:mm:ss.fff.

Permissions

Execute permissions default to the public role.

See Also

sp_addmergepullsubscription

sp_changemergepullsubscription

sp_dropmergepullsubscription

System Stored Procedures