sp_addsynctriggers (T-SQL)

Creates immediate-updating triggers at the Subscriber.

Syntax

sp_addsynctriggers {[@sub_table =] 'sub_table',
    [@sub_table_owner =] 'sub_table_owner', [@publisher =] 'publisher',
    [@publisher_db =] 'publisher_db', [@ins_proc =] 'ins_proc',
    [@upd_proc =] 'upd_proc' [,[@del_proc =] 'del_proc'}
    [,[@identity_col =] 'identity_col'] [,[@ts_col =] 'ts_col']
    [,[@filter_clause =] 'filter_clause'],
    {[@primary_key_bitmap =] 'primary_key_bitmap'}

Arguments

[@sub_table =] 'sub_table': Is the name of the Subscriber table. sub_table is sysname, with no default.
[@sub_table_owner =] 'sub_table_owner': Is the name of the owner of the Subscriber table. sub_table_owner is sysname, with no default.
[@publisher =] 'publisher': Is the name of the Publisher server. publisher is sysname, with no default.
[@publisher_db =] 'publisher_db': Is the name of the Publisher database. publisher_db is sysname, with no default. If NULL, the current database is used.
[@ins_proc =] 'ins_proc': Is the name of the stored procedure that supports synchronous transaction inserts at the Publisher. ins_proc is sysname, with no default.
[@upd_proc =] 'upd_proc': Is the name of the stored procedure that supports synchronous transaction updates at the Publisher. ins_proc is sysname, with no default.
[@del_proc =] 'del_proc': Is the name of the stored procedure that supports synchronous transaction deletes at the Publisher. ins_proc is sysname, with no default.
[@identity_col =] 'identity_col': Is the name of the identity column at the Publisher. identity_col is sysname, with a default of NULL.
[@ts_col =] 'ts_col': Is the name of the timestamp column at the Publisher. ts_col is sysname, with a default of NULL.
[@filter_clause =] 'filter_clause': Is the name of the filter clause used to create the article. filter_clause is nvarchar(4000), with a default of NULL.
[@primary_key_bitmap =] 'primary_key_bitmap': Is a bit map of the primary key columns in the table. primary_key_bitmap is varbinary(4000), with no default.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_addsynctriggers is used by the Distribution Agent in snapshot and transactional replication to enable subscription for immediate-updating Subscribers.

Permissions

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