sp-mschange-merge-agent-properties-transact-sql.md

title	sp_MSchange_merge_agent_properties (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	sp_MSchange_merge_agent_properties_TSQL sp_MSchange_merge_agent_properties
helpviewer_keywords	sp_MSchange_merge_agent_properties
ms.assetid	f775fa0f-28c7-4863-89ce-7bcfa1ab8b5e
author	stevestein
ms.author	sstein

sp_MSchange_merge_agent_properties (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Changes the properties of a Merge Agent job that runs at a [!INCLUDEmsCoName] [!INCLUDEssVersion2005] or later version Distributor. This stored procedure is used to change properties when the Publisher runs on an instance of [!INCLUDEssVersion2000]. This stored procedure is executed at the Distributor on the distribution database.

Transact-SQL Syntax Conventions

Syntax

  
sp_MSchange_merge_agent_properties [ @publisher = ] 'publisher'  
        , [ @publisher_db = ] 'publisher_db'  
        , [ @publication = ] 'publication'   
        , [ @subscriber = ] 'subscriber'   
        , [ @subscriber_db = ] 'subscriber_db'   
        , [ @property = ] 'property'   
        , [ @value = ] 'value' ]  

Arguments

[ @publisher = ] 'publisher' Is the name of the Publisher. publisher is sysname, with no default.

[ @publisher_db = ] 'publisher_db' Is the name of the publication database. publisher_db is sysname, with no default.

[ @publication = ] 'publication' Is the name of the publication. publication is sysname, with no default.

[ @subscriber = ] 'subscriber' Is the name of the Subscriber. subscriber is sysname, with no default.

[ @subscriber_db = ] 'subscriber_db' Is the name of the subscription database. subscriber_db is sysname, with no default.

[ @property = ] 'property' Is the publication property to change. property is sysname, with no default.

[ @value = ] 'value' Is the new property value. value is nvarchar(524), with a default of NULL.

This table describes the properties of the Merge Agent job that can be changed and restrictions on the values for those properties.

Property	Value	Description
description		A brief description of the subscription.
merge_job_login		Login for the [!INCLUDEmsCoName] Windows account under which the agent runs.
merge_job_password		Password for the Windows account under which the agent job runs.
publisher_login		Login to use when connecting to a Publisher to synchronize the subscription.
publisher_password		Publisher password. [!INCLUDEssNoteStrongPass]
publisher_security_mode	1	Windows Authentication. [!INCLUDEssNoteWinAuthentication]
	0	[!INCLUDEssNoVersion] Authentication.
subscriber_login		Login to use when connecting to a Subscriber to synchronize the subscription.
subscriber_password		Subscriber password. [!INCLUDEssNoteStrongPass]
subscriber_security_mode	1	Windows Authentication. [!INCLUDEssNoteWinAuthentication]
	0	[!INCLUDEssNoVersion] Authentication.

Note

After changing an agent login or password, you must stop and restart the agent before the change takes effect.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_MSchange_merge_agent_properties is used in merge replication.

When the Publisher runs on an instance of [!INCLUDEssVersion2005] or later version, you should use sp_changemergesubscription to change properties of a Merge Agent job that synchronizes a push subscription that runs at the Distributor.

Permissions

Only members of the sysadmin fixed server role at the Distributor can execute sp_MSchange_merge_agent_properties.

See Also

sp_addmergepushsubscription_agent (Transact-SQL)
sp_addmergesubscription (Transact-SQL)