This topic has not yet been rated - Rate this topic

sp_lookupcustomresolver (Transact-SQL)

SQL Server 2012

Returns the information on a business logic handler or the class identifier (CLSID) value of a COM-based custom resolver component that is registered at the Distributor. This stored procedure is executed at the Publisher on the publication database.

Topic link icon Transact-SQL Syntax Conventions

Syntax


          

sp_lookupcustomresolver [ @article_resolver = ] 'article_resolver' 
    [, [ @resolver_clsid = ] 'resolver_clsid' OUTPUT ]
    [ , [ @is_dotnet_assembly = ] is_dotnet_assembly OUTPUT ]
    [ , [ @dotnet_assembly_name = ] 'dotnet_assembly_name' OUTPUT ]
    [ , [ @dotnet_class_name = ] 'dotnet_class_name' OUTPUT ]
    [ , [ @publisher = ] 'publisher' ]

Arguments

[ @article_resolver = ] 'article_resolver': Specifies the name of the custom business logic being unregistered. article_resolver is nvarchar(255), with no default. If the business logic being removed is a COM component, then this parameter is the friendly name of the component. If the business logic is a Microsoft .NET Framework assembly, then this parameter is the name of the assembly.
[ @resolver_clsid= ] 'resolver_clsid' OUTPUT: Is the CLSID value of the COM object associated with the name of the custom business logic specified in the article_resolver parameter. resolver_clsid is nvarchar(50), with a default of NULL.
[ @is_dotnet_assembly= ] 'is_dotnet_assembly' OUTPUT: Specifies the type of custom business logic that is being registered. is_dotnet_assembly is bit, with a default of 0. 1 indicates that the custom business logic being registered is a business logic handler Assembly; 0 indicates that it is a COM component.
[ @dotnet_assembly_name= ] 'dotnet_assembly_name' OUTPUT: Is the name of the assembly that implements the business logic handler. dotnet_assembly_name is nvarchar(255), with a default value of NULL.
[ @dotnet_class_name= ] 'dotnet_class_name' OUTPUT: Is the name of the class that overrides BusinessLogicModule to implement the business logic handler. dotnet_class_name is nvarchar(255), with a default value of NULL.
[ @publisher= ] 'publisher': Is the name of the Publisher. publisher is sysname, with a default value of NULL. Use this parameter when the stored procedure is not called from the Publisher. If not specified, it is assumed that the local server is the Publisher.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_lookupcustomresolver is used in merge replication.

sp_lookupcustomresolver returns a NULL value for resolver_clsid when the component is not registered at the Distribution and a value of "00000000-0000-0000-0000-000000000000" when the registration belongs to a .NET Framework assembly registered as a business logic handler.

sp_lookupcustomresolver is called by sp_addmergearticle and sp_changemergearticle to validate the specified article_resolver.

Permissions

Only members of the db_owner fixed database role on the publication database can execute sp_lookupcustomresolver.

Reference

sp_registercustomresolver (Transact-SQL)

sp_unregistercustomresolver (Transact-SQL)

System Stored Procedures (Transact-SQL)

Concepts

Advanced Merge Replication Conflict Detection and Resolution

Execute Business Logic During Merge Synchronization

Implement a Business Logic Handler for a Merge Article

Specify a Merge Article Resolver

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD