Partilhar via

sp_lookupcustomresolver (Transact-SQL)

  • Artigo

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 iconTransact-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.

See Also

Reference

sp_registercustomresolver (Transact-SQL)
sp_unregistercustomresolver (Transact-SQL)
System Stored Procedures (Transact-SQL)

Other Resources

Advanced Merge Replication Conflict Detection and Resolution
Executing Business Logic During Merge Synchronization
How to: Implement a Business Logic Handler for a Merge Article (Replication Programming)
How to: Specify a Merge Article Resolver (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance