SQL Remote User's Guide
Command Reference for Adaptive Server Enterprise
To change the resolution objects for a table marked for SQL Remote replication.
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. |
sp_remove_remote_table procedure
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.
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:
sp_add_remote_table Customer, resolve_Cust, old_Cust, remote_Cust go