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.