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 =] '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.
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. |
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.
See Also
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)
คำติชม
https://aka.ms/ContentUserFeedback
เร็วๆ นี้: ตลอดปี 2024 เราจะขจัดปัญหา GitHub เพื่อเป็นกลไกคำติชมสำหรับเนื้อหา และแทนที่ด้วยระบบคำติชมใหม่ สำหรับข้อมูลเพิ่มเติม ให้ดู:ส่งและดูข้อคิดเห็นสำหรับ