sp_unregistercustomresolver (Transact-SQL)sp_unregistercustomresolver (Transact-SQL)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions)

撤消注册以前注册的业务逻辑模块。Unregisters a previously registered business logic module. 业务逻辑的形式可以是 COM 组件或 MicrosoftMicrosoft .NET Framework 程序集。Business logic can be in the form of either a COM component or a MicrosoftMicrosoft .NET Framework assembly. 此存储过程在注册自定义业务逻辑的分发服务器中执行。This stored procedure is executed on the Distributor where the custom business logic was registered.

主题链接图标 Transact-SQL 语法约定Topic link icon Transact-SQL Syntax Conventions

语法Syntax

  
sp_unregistercustomresolver [ @article_resolver = ] 'article_resolver'   

参数Arguments

[ @article_resolver = ] 'article_resolver' 指定正在注销的自定义业务逻辑的名称。[ @article_resolver = ] 'article_resolver' Specifies the name of the custom business logic being unregistered. article_resolvernvarchar (255),无默认值。article_resolver is nvarchar(255), with no default. 如果要删除的业务逻辑是 COM 组件,则该参数是此组件的友好名称。If the business logic being removed is a COM component, this parameter is the friendly name of the component. 如果业务逻辑是 .NET Framework 程序集,则该参数是此程序集的名称。If the business logic is a .NET Framework assembly, this parameter is the name of the assembly.

返回代码值Return Code Values

0 (成功) 或 1 (失败) 0 (success) or 1 (failure)

备注Remarks

sp_unregistercustomresolver 用于合并复制。sp_unregistercustomresolver is used in merge replication.

在复制拓扑中的任何服务器上使用 sp_enumcustomresolvers ,以返回已注册的自定义业务逻辑模块或可用于拓扑的 COM 解析器的列表。Use sp_enumcustomresolvers at any server in the replication topology to return the list of registered custom business logic modules or COM resolvers available to the topology.

权限Permissions

只有 sysadmin 固定服务器角色的成员或 db_owner 固定数据库角色的成员才能执行 sp_unregistercustomresolverOnly members of the sysadmin fixed server role or db_owner fixed database role can execute sp_unregistercustomresolver.

另请参阅See Also

sp_lookupcustomresolver (Transact-sql) sp_lookupcustomresolver (Transact-SQL)
sp_registercustomresolver (Transact-sql) sp_registercustomresolver (Transact-SQL)
系统存储过程 (Transact-SQL)System Stored Procedures (Transact-SQL)