sp_changemergesubscription (T-SQL)

Changes a merge push or pull subscription.

Syntax

sp_changemergesubscription [[@publication =] 'publication']
    [,[@subscriber =] 'subscriber' [,[@subscriber_db =] 'subscriber_db']
    [,[@property =] 'property'] [,[@value =] 'value']

Arguments

[@publication =] 'publication'

Is the name of the publication to change. publication is sysname, with a default of NULL The publication must already exist and must conform to the rules for identifiers.

[@subscriber =] 'subscriber'

Is the name of the Subscriber. subscriber is sysname with a default of NULL.

[@subscriber_db =] 'subscriber_db'

Is the name of the subscription database. subscriber_db is sysname, with a default of NULL

[@property =] 'property'

Is the property to change for the given publication. 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 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_changemergesubscription is used in merge replication.

Permissions

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

See Also