sp_changemergepullsubscription (T-SQL)

Changes the properties of the merge pull subscription.

Syntax

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

Argument

[@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 these values.

 

Value	Description
sync_type	Subscription synchronization type.
priority	Can change only at the Publisher or Republisher.
description	Description of this merge pull subscription.
NULL (default)

[@value =] 'value'

Is the new value for the specified property. value is nvarchar(255), and can be one of these values.

 

Value	Description
sync_type	Can be automatic or none.
priority	Priority assigned.
description	Description of the subscription.
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