Skip to content

Latest commit

 

History

History
84 lines (60 loc) · 2.89 KB

sp-scriptpublicationcustomprocs-transact-sql.md

File metadata and controls

84 lines (60 loc) · 2.89 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sp_scriptpublicationcustomprocs (Transact-SQL)
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.
markingmyname
maghan
randolphwest
04/08/2024
sql
replication
reference
sp_scriptpublicationcustomprocs
sp_scriptpublicationcustomprocs_TSQL
sp_scriptpublicationcustomprocs
TSQL

sp_scriptpublicationcustomprocs (Transact-SQL)

[!INCLUDE SQL Server SQL MI]

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.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

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

Arguments

[ @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

[!INCLUDE ssinternalonly-md]

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.

Remarks

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

Permissions

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.

Related content