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