User's Manual

sp_modify_remote_table procedure
Purpose To change the resolution objects for a table marked for SQL Remote
replication.
Syntax sp_modify_remote_table table_name,
[ resolve_name, ]
[ old_row_name, ]
[ remote_row_name ]
Argument Description
table_name A table marked for SQL Remote replication.
resolve_procedure The name of the new stored procedure for carrying
out actions when a conflict occurs.
old_row_name The name of the new table for holding the values in
the table when a conflict occurs.
remote_row_name The name of the new table for holding the values at
the remote database when a conflict-causing UPDATE
statement was applied.
See also “sp_add_remote_table procedure” on page 384
“sp_remove_remote_table procedure” on page 430
“Managing conflicts” on page 165.
Description Each table in a database must be marked for replication by using
sp_add_remote_table before it can be included in any SQL Remote
publications.
The sp_modify_remote_table allows you to change the way in which
conflict resolution is carried out for update conflicts occurring on this table.
The arguments are, in addition to the table name, the object names required
for custom conflict resolution. If you are implementing custom conflict
resolution, you must supply the names of two tables, and a stored procedure.
The sp_modify_remote_table procedure does not check for the existence of
the conflict resolution arguments: you can create them either before or after
marking the table for replication.
The two tables must have the same columns and data types as table
table_name .
Example The following statement instructs SQL Remote to use the resolve_Cust
procedure, the old_Cust table, and the remote_Cust table to resolve update
conflicts on the Customer table:
400