sp_articlesynctranprocs (T-SQL)

Generates procedures at the Publisher that are called by immediate updating triggers at the Subscriber.

Syntax

sp_articlesynctranprocs [@publication =] 'publication',
    [@article =] 'article', [@ins_proc =] 'ins_proc',
    [@upd_proc =] 'upd_proc', [@del_proc =] 'del_proc'
    [,[@autogen =] 'autogen']

Arguments

[@publication =] 'publication': Is the name of the publication. publication is sysname, with no default.
[@article =] 'article': Is the name of the article. article is sysname, with no default.
[@ins_proc =] 'ins_proc': Is the name of the stored procedure that supports immediate updating Subscriber inserts associated with this article. ins_proc is sysname, with no default.
[@upd_proc =] 'upd_proc': Is the name of the stored procedure that supports immediate updating Subscriber updates associated with this article. upd_proc is sysname, with no default.
[@del_proc =] 'del_proc': Is the name of the stored procedure that supports immediate updating Subscriber deletes associated with this article. del_proc is sysname, with no default.
[@autogen =] 'autogen': Is whether to autogenerate stored procedures. autogen is nvarchar(5), with a default of true.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_articlesynctranprocs is used in snapshot and transactional replication.

Permissions

Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_articlesynctranprocs.