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.
.gif "Topic link icon")
Transact-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)