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

Page 418
Image 418
Sybase DC38133-01-0902-01 Spmodifyremotetable procedure, Spaddremotetable procedure on, Spremoveremotetable procedure on