sp_setrepdefmode has been enhanced to support the SQL statement replication.
sp_setrepdefmode now includes options to:
Enable or disable SQL statement replication for a specific DML operation
Configure the threshold that must be reached to activate SQL statement replication
The DML operations that apply to SQL statement replication include:
U – update
D – delete
I – insert select
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.
