sp_register_custom_scripting (Transact-SQL)

[ @type = ] 'type'

Is the type of custom stored procedure or script being registered. type is varchar(16), with no default, and can be one of the following values.

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

[ @value= ] 'value'

Name of a stored procedure or name and fully-qualified path to the Transact-SQL script file that is being registered. value is nvarchar(1024), with no default.

Note
Specifying NULL for valueparameter will unregister a previously registered script, which is the same as running sp_unregister_custom_scripting.

When the value of type is custom_script, the name and full path of a Transact-SQL script file is expected. Otherwise, value must be the name of a registered stored procedure.

[ @publication= ] 'publication'

Name of the publication for which the custom stored procedure or script is being registered. publication is sysname, with a default of NULL.

[ @article= ] 'article'

Name of the article for which the custom stored procedure or script is being registered. article is sysname, with a default of NULL.

0 (success) or 1 (failure)

sp_register_custom_scripting is used in snapshot and transactional replication.

This stored procedure should be executed prior to making a schema change to a replicated table. For more information about using this stored procedure, see Regenerate Custom Transactional Procedures to Reflect Schema Changes.

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

Reference