sp_lookupcustomresolver (Transact-SQL)
Collapse the table of content
Expand the table of content

sp_lookupcustomresolver (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

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' ]

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

0 (success) or 1 (failure)

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.

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

Community Additions

© 2016 Microsoft