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

Other Resources

System Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2008 Assistance