sp_changemergepullsubscription (Transact-SQL)

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

Transact-SQL Syntax Conventions

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. 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.

  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 SQL Server Authentication
  distributor_password		Password (encrypted) used at the Distributor for SQL Server Authentication.
  distributor_security_mode	1	Use Windows Authentication when connecting to the Distributor.
  	0	Use SQL Server 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 at the Publisher instead to modify the priority of a 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	Use SQL Server 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

Reference

sp_addmergepullsubscription (Transact-SQL)
sp_dropmergepullsubscription (Transact-SQL)
sp_helpmergepullsubscription (Transact-SQL)
System Stored Procedures (Transact-SQL)

Other Resources

How to: View and Modify Pull Subscription Properties (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance