sp_changemergepullsubscription (Transact-SQL)

 

Applies To: SQL Server

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

Topic link icon Transact-SQL Syntax Conventions

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

[ @publication=] 'publication'
Is the name of the publication. publication is sysname, with a default of %.

[ @publisher=] 'publisher'
Is the name of the Publisher. publisheris sysname, with a default of %.

[ @publisher_db=] 'publisher_db'
Is the name of the Publisher database. publisher_dbis 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. valueis nvarchar(255), and can be one of the values in the table.

PropertyValueDescription
alt_snapshot_folderLocation where the snapshot folder is stored if the location is other than or in addition to the default location.
descriptionDescription of this merge pull subscription.
distributorName of the Distributor.
distributor_loginLogin ID used at the Distributor for SQL Server Authentication
distributor_passwordPassword (encrypted) used at the Distributor for SQL Server Authentication.
distributor_security_mode1Use Windows Authentication when connecting to the Distributor.
0Use SQL Server Authentication when connecting to the Distributor.
dynamic_snapshot_locationPath to the folder where the snapshot files are saved.
ftp_addressAvailable for backward compatibility only. Is the network address of the File Transfer Protocol (FTP) service for the Distributor.
ftp_loginAvailable for backward compatibility only. Is the username used to connect to the FTP service.
ftp_passwordAvailable for backward compatibility only. Is the user password used to connect to the FTP service.
ftp_portAvailable for backward compatibility only. Is the port number of the FTP service for the Distributor.
hostnameSpecifies a the value for HOST_NAME() when this function is used in the WHERE clause of a join filter or logical record relationship.
internet_loginLogin that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using Basic Authentication.
internet_passwordPassword for the login that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using Basic Authentication.
internet_security_mode1Use Windows Authentication when connecting to the Web server that is hosting Web synchronization.
0Use Basic Authentication when connecting to the Web server that is hosting Web synchronization.
internet_timeoutLength of time, in seconds, before a Web synchronization request expires.
internet_urlURL that represents the location of the replication listener for Web synchronization.
merge_job_loginLogin for the Windows account under which the agent runs.
merge_job_passwordPassword for the Windows account under which the agent runs.
priorityAvailable for backward compatibility only; run sp_changemergesubscription at the Publisher instead to modify the priority of a subscription.
publisher_loginLogin ID used at the Publisher for SQL Server Authentication.
publisher_passwordPassword (encrypted) used at the Publisher for SQL Server Authentication.
publisher_security_mode0Use SQL Server Authentication when connecting to the Publisher.
1Use Windows Authentication when connecting to the Publisher.
2Synchronization 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_typeautomaticSchema and initial data for published tables are transferred to the Subscriber first.
noneSubscriber already has the schema and initial data for published tables; system tables and data are always transferred.
use_ftptrueUse FTP instead of the typical protocol to retrieve snapshots.
falseUse the typical protocol to retrieve snapshots.
use_web_synctrueSubscription can be synchronized over HTTP.
falseSubscription cannot be synchronized over HTTP.
use_interactive_resolvertrueInteractive resolver is used during reconciliation.
falseInteractive resolver is not used.
working_directoryFully-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.

0 (success) or 1 (failure)

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.

Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_changemergepullsubscription.

View and Modify Pull Subscription Properties
sp_addmergepullsubscription (Transact-SQL)
sp_dropmergepullsubscription (Transact-SQL)
sp_helpmergepullsubscription (Transact-SQL)
System Stored Procedures (Transact-SQL)

Community Additions

ADD
Show: