Skip to content

sp-unregister-custom-scripting-transact-sql.md

Latest commit

 

History

History
70 lines (55 loc) · 3.11 KB

sp-unregister-custom-scripting-transact-sql.md

File metadata and controls

70 lines (55 loc) · 3.11 KB
title sp_unregister_custom_scripting (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
replication
ms.tgt_pltfrm
ms.topic language-reference
applies_to
SQL Server
f1_keywords
sp_unregister_custom_scripting_TSQL
sp_unregister_custom_scripting
helpviewer_keywords
sp_unregister_custom_scripting
ms.assetid b6e9e0d2-9144-434d-88af-4874f2582399
caps.latest.revision 26
author BYHAM
ms.author rickbyh
manager jhubbard

sp_unregister_custom_scripting (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

This stored procedure removes a user-defined custom stored procedure or [!INCLUDEtsql] script file that was registered by executing sp_register_custom_scripting. This stored procedure is executed at the Publisher on the publication database.

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
sp_unregister_custom_scripting [ @type  = ] 'type'  
    [ , [ @publication = ] 'publication' ]  
    [ , [ @article = ] 'article' ]

Arguments

[ @type = ] 'type'
Is the type of custom stored procedure or script being removed. type is varchar(16), with no default, and can be one of the following values.

Value Description
insert Registered custom stored procedure or script is executed when an INSERT statement is replicated.
update Registered custom stored procedure or script is executed when an UPDATE statement is replicated.
delete Registered custom stored procedure or script is executed when a DELETE statement is replicated.
custom_script Registered custom stored procedure or script is executed at the end of the data definition language (DDL) trigger.

[ @publication = ] 'publication'
Name of the publication for which the custom stored procedure or script is being removed. publication is sysname, with a default of NULL.

[ @article = ] 'article'
Name of the article for which the custom stored procedure or script is being removed. article is sysname, with a default of NULL.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_unregister_custom_scripting is used in snapshot and transactional replication.

Permissions

Only members of the sysadmin fixed server role, the db_owner fixed database role, or the db_ddladmin fixed database role can execute sp_unregister_custom_scripting.

See Also

sp_register_custom_scripting (Transact-SQL)