sp_scriptpublicationcustomprocs (Transact-SQL)

Applies to: SQL Server Azure SQL Managed Instance

Scripts the custom INSERT, UPDATE, and DELETE procedures for all table articles in a publication in which the autogenerate custom procedure schema option is enabled. sp_scriptpublicationcustomprocs can be useful for setting up subscriptions for which the snapshot is applied manually.

Transact-SQL syntax conventions


    [ @publication = ] N'publication'
    [ , [ @publisher = ] N'publisher' ]
    [ , [ @usesqlclr = ] usesqlclr ]
[ ; ]


[ @publication = ] N'publication'

The name of the publication. @publication is sysname, with no default.

[ @publisher = ] N'publisher'

The name of the publisher. @publisher is sysname, with a default of NULL.

[ @usesqlclr = ] usesqlclr

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

Return code values

0 (success) or 1 (failure).

Result set

Returns a result set that consists of a single nvarchar(4000) column. The result set forms the complete CREATE PROCEDURE statement necessary to create the custom stored procedure.


Custom procedures aren't scripted for articles without the autogenerated custom procedure (0x2) schema option.

The following procedures are used by sp_scriptpublicationcustomprocs to create procedures the Subscriber, and shouldn't be executed directly:

  • sp_script_reconciliation_delproc
  • sp_script_reconciliation_insproc
  • sp_script_reconciliation_vdelproc
  • sp_script_reconciliation_xdelproc
  • sp_scriptdelproc
  • sp_scriptinsproc
  • sp_scriptmappedupdproc
  • sp_scriptupdproc
  • sp_scriptvdelproc
  • sp_scriptvupdproc
  • sp_scriptxdelproc
  • sp_scriptxupdproc


Execute permission is granted to public. A procedural security check is performed inside this stored procedure to restrict access to members of the sysadmin fixed server role and db_owner fixed database role in current database.