sp_setrepdefmode has been enhanced
to support SQL statement replication.
sp_setrepdefmode includes options
to:
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 “System Changes” chapter in the Adaptive Server
Enterprise 15.0.3 New Features Guide.