sp_registercustomresolver (Transact-SQL)

Applies to: SQL Server

Registers a business logic handler or a COM-based custom resolver that can be invoked during the merge replication synchronization process. This stored procedure is executed at the Distributor.

Transact-SQL syntax conventions

Syntax

sp_registercustomresolver
    [ @article_resolver = ] N'article_resolver'
    [ , [ @resolver_clsid = ] N'resolver_clsid' ]
    [ , [ @is_dotnet_assembly = ] N'is_dotnet_assembly' ]
    [ , [ @dotnet_assembly_name = ] N'dotnet_assembly_name' ]
    [ , [ @dotnet_class_name = ] N'dotnet_class_name' ]
[ ; ]

Arguments

[ @article_resolver = ] N'article_resolver'

Specifies the friendly name for the custom business logic being registered. @article_resolver is nvarchar(255), with no default.

[ @resolver_clsid = ] N'resolver_clsid'

Specifies the CLSID value of the COM object that being registered. @resolver_clsid is nvarchar(50), with a default of NULL. This parameter must be set to a valid CLSID or set to NULL when registering a business logic handler assembly.

[ @is_dotnet_assembly = ] N'is_dotnet_assembly'

Specifies the type of custom business logic that is being registered. @is_dotnet_assembly is nvarchar(10), with a default of false.

  • true indicates that the custom business logic being registered is a business logic handler Assembly.
  • false indicates that custom business logic is a COM component.

[ @dotnet_assembly_name = ] N'dotnet_assembly_name'

The name of the assembly that implements the business logic handler. @dotnet_assembly_name is nvarchar(255), with a default of NULL. You must specify the full path to the assembly if it's not deployed in the same directory as the Merge Agent executable, in the same directory as the application that synchronously starts the Merge Agent, or in the global assembly cache (GAC).

[ @dotnet_class_name = ] N'dotnet_class_name'

The name of the class that overrides BusinessLogicModule to implement the business logic handler. @dotnet_class_name is nvarchar(255), with a default of NULL. The name should be specified in the form <Namespace>.<Classname>.

Return code values

0 (success) or 1 (failure).

Remarks

sp_registercustomresolver is used in merge replication.

Permissions

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