sp_changemergepullsubscription

Transact-SQL Reference

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

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

See Also

sp_addmergepullsubscription

sp_dropmergepullsubscription

sp_helpmergepullsubscription

System Stored Procedures