Transact-SQL Reference

sp_changemergepullsubscription

Changes the properties of the merge pull subscription. This stored procedure is executed at the Subscriber on the subscription database.

Syntax

sp_changemergepullsubscription [ [ @publication = ] 'publication' ]
    [ , [ @publisher = ] 'publisher' ]
    [ , [ @publisher_db = ] 'publisher_db' ]
    [ , [ @property = ] 'property' ]
    [ , [ @value = ] 'value' ]

Arguments

[@publication =] 'publication'

Is the name of the publication. publication is sysname, with a default of %.

[@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 %.

[@property =] 'property'

Is the name of the property to change. property is sysname, and can be one of the values in the table.

[@value =] 'value'

Is the new value for the specified property. value is nvarchar(255), and can be one of the values in the table.

Property	Value	Description
sync_type	automatic or none	Is the subscription synchronization type. sync_type is nvarchar(15), with a default of automatic. Can be automatic or none. If automatic, the schema and initial data for published tables are transferred to the Subscriber first. If none, it is assumed the Subscriber already has the schema and initial data for published tables. System tables and data are always transferred.
priority		Available for backward compatibility only; run sp_changemergesubscription at the Publisher instead to modify the priority of a subscription.
description		Description of this merge pull subscription.
publisher_login		Login ID used at the Publisher for SQL Server Authentication.
publisher_password		Password (encrypted) used at the Publisher for SQL Server Authentication.
publisher_security_mode	0 = SQL Server Authentication 1 = Windows Authentication 2 = The synchronization triggers use a static sysservers entry to do RPC, and the Publisher must be defined in the sysservers table as a remote server or linked server	Security mode implemented at the Publisher.
distributor		Name of the Distributor.
distributor_login		Login ID used at the Distributor for SQL Server Authentication
distributor_password		Password (encrypted) used at the Distributor for SQL Server Authentication.
distributor_security_mode	0 = SQL Server Authentication 1 = Windows Authentication	Security mode implemented at the Distributor.
ftp_address		Available for backward compatibility only. Is the network address of the FTP service for the Distributor.
ftp_port		Available for backward compatibility only. Is the port number of the FTP service for the Distributor.
ftp_login		Available for backward compatibility only. Is the username used to connect to the FTP service.
ftp_password		Available for backward compatibility only. Is the user password used to connect to the FTP service.
alt_snapshot_folder		Location where the snapshot folder is stored if the location is other than or in addition to the default location.
working_directory		Fully qualified path to the directory where snapshot files are transferred using FTP when that option is specified.
use_ftp		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.
use_interactive_resolver	0 or 1	Determines whether or not the interactive resolver is used during reconciliation. If 0, the interactive resolver is not used.
offload_agent	0 or 1 bit	Specifies if the agent can be activated and run remotely. If 0, the agent cannot be remotely activated.
offload_server		Name of the server used for remote activation.
dynamic_snapshot_location		Path to the folder where the snapshot files are saved.
NULL (default)

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_changemergepullsubscription is used in merge replication.

The current server and current database are assumed to be the Subscriber and Subscriber database.

Permissions