Enabling SQL statement replication

sp_setrepdefmode has been enhanced to support the SQL statement replication.

sp_setrepdefmode

sp_setrepdefmode now includes options to:

The DML operations that apply to SQL statement replication include:

When the table replication mode is set to any combination of UDI the RepAgent sends additional information to enable SQL statement replication for the specified DML operation.

For example, to enable SQL statement replication for update, delete and insert select operations on table t, enter:

sp_setrepdefmode t, 'UDI', 'on'
go

See “sp_setrepdefmode” in the Adaptive Server documentation.