Applies To: SQL Server
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.
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.
Only members of the db_owner fixed database role on the publication database can execute sp_lookupcustomresolver.
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
System Stored Procedures (Transact-SQL)