.png)
sp_scriptpublicationcustomprocs (Transact-SQL)
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.
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
