sp_MSchange_merge_agent_properties (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

sp_MSchange_merge_agent_properties (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Changes the properties of a Merge Agent job that runs at a Microsoft SQL Server 2005 or later version Distributor. This stored procedure is used to change properties when the Publisher runs on an instance of SQL Server 2000. This stored procedure is executed at the Distributor on the distribution database.

Topic link icon Transact-SQL Syntax Conventions

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

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

PropertyValueDescription
descriptionA brief description of the subscription.
merge_job_loginLogin for the Microsoft Windows account under which the agent runs.
merge_job_passwordPassword for the Windows account under which the agent job runs.
publisher_loginLogin to use when connecting to a Publisher to synchronize the subscription.
publisher_passwordPublisher password.

 Do not use a blank password. Use a strong password.
publisher_security_mode1Windows Authentication.

 When possible, use Windows Authentication.
0SQL Server Authentication.
subscriber_loginLogin to use when connecting to a Subscriber to synchronize the subscription.
subscriber_passwordSubscriber password.

 Do not use a blank password. Use a strong password.
subscriber_security_mode1Windows Authentication.

 When possible, use Windows Authentication.
0SQL Server Authentication.
System_CAPS_ICON_note.jpg Note


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

0 (success) or 1 (failure)

sp_MSchange_merge_agent_properties is used in merge replication.

When the Publisher runs on an instance of SQL Server 2005 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.

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

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

Community Additions

ADD
Show:
© 2016 Microsoft