sp_enumcustomresolvers (Transact-SQL)

Returns a list of all available business logic handlers and custom resolvers registered at the Distributor. This stored procedure is executed at the Publisher on any database.

Topic link iconTransact-SQL Syntax Conventions

Syntax

sp_enumcustomresolvers [ [ @distributor =] 'distributor']

Arguments

  • [ @distributor =] 'distributor'
    Is the name of the Distributor where the custom resolver is located. distributor is sysname, with a default of NULL. This parameter is deprecated and will be removed in a future release.

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column name Data type Description

article_resolver

nvarchar(255)

Friendly name for the business logic handler or conflict resolver.

resolver_clsid

nvarchar(50)

Class ID (CLSID) of the COM-based resolver. For a business logic handler, this column returns a zero CLSID value.

is_dotnet_assembly

bit

Indicates whether the registration is for a business logic handler.

0 = COM-based conflict resolver

1 = business logic handler

dotnet_assembly_name

nvarchar(255)

The name of the Microsoft .NET Framework assembly that implements the business logic handler.

dotnet_class_name

nvarchar(255)

Is the name of the class that overrides BusinessLogicModule to implement the business logic handler.

Remarks

sp_enumcustomresolvers is used in merge replication.

Permissions

Only members of the sysadmin fixed server role and the db_owner fixed database role can execute sp_enumcustomresolvers.

See Also

Reference

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

Other Resources

How to: Implement a Business Logic Handler for a Merge Article (Replication Programming)
How to: Implement a COM-Based Custom Conflict Resolver for a Merge Article (Replication Programming)

Help and Information

Getting SQL Server 2005 Assistance