How to choose a resolver (Transact-SQL)

How to Install SQL Server 2000

How To

How to choose a resolver (Transact-SQL)

  • If you are using stored procedures to create a publication and want to specify the resolver, set the @article_resolver = parameter of the replication stored procedure sp_addmergearticle to the name of the custom resolver. If the custom resolver is a stored procedure, also set the @resolver_info = parameter to the name of the stored procedure.

  • If you are changing the resolver properties of an existing merge article in a publication, set the @property = parameter of the replication stored procedure sp_changemergearticle to article_resolver, and then set the @value = parameter to the name of the custom resolver. If the custom resolver is a stored procedure, execute a second sp_changemergearticle statement, set the @property = parameter to resolver_info, and then set the @value = parameter to the name of the stored procedure.