| title | sp_enumcustomresolvers (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 81bd0d3a-48dc-42b1-b662-c630f61fc630 | ||
| caps.latest.revision | 22 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
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.
Transact-SQL Syntax Conventions
sp_enumcustomresolvers [ [ @distributor =] 'distributor']
[ @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.
| 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 [!INCLUDEmsCoName] .NET Framework assembly that implements the business logic handler. |
| dotnet_class_name | nvarchar(255) | Is the name of the class that overrides xref:Microsoft.SqlServer.Replication.BusinessLogicSupport.BusinessLogicModule to implement the business logic handler. |
0 (success) or 1 (failure)
sp_enumcustomresolvers is used in merge replication.
Only members of the sysadmin fixed server role and the db_owner fixed database role can execute sp_enumcustomresolvers.
Implement a Business Logic Handler for a Merge Article
Implement a Custom Conflict Resolver for a Merge Article
sp_lookupcustomresolver (Transact-SQL)
sp_unregistercustomresolver (Transact-SQL)
System Stored Procedures (Transact-SQL)