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.
sp_unregister_custom_scripting [ @type = ] 'type' [ , [ @publication = ] 'publication' ] [ , [ @article = ] 'article' ]
[ @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.
|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)
sp_unregister_custom_scripting is used in snapshot and transactional replication.
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.