sp_changemergepublication (T-SQL)

Changes the properties of a merge publication.

Syntax

sp_changemergepublication [@publication =] 'publication'
    [,[@property =] 'property'] [,[@value =] 'value']

Arguments

[@publication =] 'publication'

Is the name of the publication. publication is sysname, with no default.

[@property =] 'property'

Is the property to change for the given publication. property is sysname, and can be one of these values.

 

Value	Description
description	Description of the publication.
status	Status of the publication.
retention	Amount of change, in days, to save for the given publication.
sync_mode	Mode of the synchronization.
allow_push	Push subscriptions are created for the given publication.
allow_pull	Pull subscriptions are created for the given publication.
allow_anonymous	Anonymous subscriptions are created for the given publication.
enabled_for_internet	The publication is enabled for the Internet.
centalized_conflicts	Conflict records are stored on the given Publisher.
snapshot_ready	The snapshot for the publication is available.
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
description	Description of the publication.
status	Status of the property. Can be active, unsynced, or inactive.
retention	New replication period.
sync_mode	Can be native, character, bcp native, or bcp character.
allow_push	Can be true or false.
allow_pull	Can be true or false.
allow_anonymous	Can be true or false.
enabled_for_internet	Can be true or false.
centalized_conflicts	Can be true or false.
snapshot_ready	Can be true or false.
NULL (default)

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_changemergepublication is used in merge replication.

Permissions

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

See Also