Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_changemergepullsubscription (Transact-SQL)

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.

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.