sp_unregister_custom_scripting (Transact-SQL)
Applies to: SQL Server
This stored procedure removes a user-defined custom stored procedure or Transact-SQL script file that was registered by executing sp_register_custom_scripting. This stored procedure is executed at the Publisher on the publication database.
Transact-SQL syntax conventions
Syntax
sp_unregister_custom_scripting
[ @type = ] 'type'
[ , [ @publication = ] N'publication' ]
[ , [ @article = ] N'article' ]
[ ; ]
Arguments
[ @type = ] 'type'
The type of custom stored procedure or script being removed. @type is varchar(16), 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 = ] N'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 = ] N'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
.
Related content
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru