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


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