--- title: "sp_changemergepullsubscription (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: sql ms.prod_service: "database-engine" ms.reviewer: "" ms.technology: replication ms.topic: "language-reference" f1_keywords: - "sp_changemergepullsubscription" - "sp_changemergepullsubscription_TSQL" helpviewer_keywords: - "sp_changemergepullsubscription" ms.assetid: 5e0d04f2-6175-44a2-ad96-a8e2986ce4c9 author: stevestein ms.author: sstein --- # sp_changemergepullsubscription (Transact-SQL) [!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)] Changes the properties of the merge pull subscription. This stored procedure is executed at the Subscriber on the subscription database. ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md) ## 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| |--------------|-----------|-----------------| |**alt_snapshot_folder**||Location where the snapshot folder is stored if the location is other than or in addition to the default location.| |**description**||Description of this merge pull subscription.| |**distributor**||Name of the Distributor.| |**distributor_login**||Login ID used at the Distributor for [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication| |**distributor_password**||Password (encrypted) used at the Distributor for [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication.| |**distributor_security_mode**|**1**|Use Windows Authentication when connecting to the Distributor.| ||**0**|Use [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication when connecting to the Distributor.| |**dynamic_snapshot_location**||Path to the folder where the snapshot files are saved.| |**ftp_address**||Available for backward compatibility only. Is the network address of the File Transfer Protocol (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.| |**ftp_port**||Available for backward compatibility only. Is the port number of the FTP service for the Distributor.| |**hostname**||Specifies a the value for HOST_NAME() when this function is used in the WHERE clause of a join filter or logical record relationship.| |**internet_login**||Login that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using Basic Authentication.| |**internet_password**||Password for the login that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using Basic Authentication.| |**internet_security_mode**|**1**|Use Windows Authentication when connecting to the Web server that is hosting Web synchronization.| ||**0**|Use Basic Authentication when connecting to the Web server that is hosting Web synchronization.| |**internet_timeout**||Length of time, in seconds, before a Web synchronization request expires.| |**internet_url**||URL that represents the location of the replication listener for Web synchronization.| |**merge_job_login**||Login for the Windows account under which the agent runs.| |**merge_job_password**||Password for the Windows account under which the agent runs.| |**priority**||Available for backward compatibility only; run [sp_changemergesubscription](../../relational-databases/system-stored-procedures/sp-changemergesubscription-transact-sql.md) at the Publisher instead to modify the priority of a subscription.| |**publisher_login**||Login ID used at the Publisher for [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication.| |**publisher_password**||Password (encrypted) used at the Publisher for [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication.| |**publisher_security_mode**|**0**|Use [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication when connecting to the Publisher.| ||**1**|Use Windows Authentication when connecting to the Publisher.| ||**2**|Synchronization triggers use a static **sysservers** entry to do remote procedure call (RPC), and the Publisher must be defined in the **sysservers** table as a remote server or linked server.| |**sync_type**|**automatic**|Schema and initial data for published tables are transferred to the Subscriber first.| ||**none**|Subscriber already has the schema and initial data for published tables; system tables and data are always transferred.| |**use_ftp**|**true**|Use FTP instead of the typical protocol to retrieve snapshots.| ||**false**|Use the typical protocol to retrieve snapshots.| |**use_web_sync**|**true**|Subscription can be synchronized over HTTP.| ||**false**|Subscription cannot be synchronized over HTTP.| |**use_interactive_resolver**|**true**|Interactive resolver is used during reconciliation.| ||**false**|Interactive resolver is not used.| |**working_directory**||Fully-qualified path to the directory where snapshot files are transferred using FTP when that option is specified.| |NULL (default)||Returns the list of supported values for *property*.| ## 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. After changing an agent login or password, you must stop and restart the agent before the change takes effect. ## Permissions Only members of the **sysadmin** fixed server role or **db_owner** fixed database role can execute **sp_changemergepullsubscription**. ## See Also [View and Modify Pull Subscription Properties](../../relational-databases/replication/view-and-modify-pull-subscription-properties.md) [sp_addmergepullsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addmergepullsubscription-transact-sql.md) [sp_dropmergepullsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropmergepullsubscription-transact-sql.md) [sp_helpmergepullsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpmergepullsubscription-transact-sql.md) [System Stored Procedures (Transact-SQL)](../../relational-databases/system-stored-procedures/system-stored-procedures-transact-sql.md)