sp_enumcustomresolvers (Transact-SQL)
Applies to: SQL Server
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
Syntax
sp_enumcustomresolvers [ [ @distributor = ] N'distributor' ]
[ ; ]
Arguments
[ @distributor = ] N'distributor'
The name of the Distributor where the custom resolver is located. @distributor is sysname, with a default of NULL
.
This parameter is deprecated and is maintained for backward compatibility of scripts.
Result set
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 resolver1 = 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) | The name of the class that overrides BusinessLogicModule that implements the business logic handler. |
Return code values
0
(success) or 1
(failure).
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
.