| title | sp_scriptpublicationcustomprocs (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/04/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | b06102d5-4284-4834-b126-bc0baea49be5 | ||
| caps.latest.revision | 20 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Scripts the custom INSERT, UPDATE, and DELETE procedures for all table articles in a publication in which the auto-generate custom procedure schema option is enabled. sp_scriptpublicationcustomprocs is particularly useful for setting up subscriptions for which the snapshot is applied manually.
Transact-SQL Syntax Conventions
sp_scriptpublicationcustomprocs [ @publication = ] 'publication_name'
[ @publication=] 'publication_name'
Is the name of the publication. publication_name is sysname with no default.
0 (success) or 1 (failure)
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 are not scripted for articles without the auto-generate custom procedure (0x2) schema option.
The following procedures are used by sp_scriptpublicationcustomprocs to create procedures the Subscriber and should not 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.