sp_setrepdbmode has been added to support SQL statement replication.
sp_setrepdbmode allows you to enable SQL statement replication for a specific DML operation.
The DML operations that apply to SQL statement replication include:
U – update
D – delete
I – insert select
S – select into
When the database replication mode is set to any combination of UDIS the RepAgent sends both individual log records and the information needed by Replication Server to build the SQL statement.
For example, to replicate delete statements as SQL statement replication and also enable replication of select into, enter:
sp_setrepdbmode pdb, 'DS', 'on'
You can set SQL statement replication at the database level only when the database has been marked for replication by setting sp_reptostandby to ALL or L1.
See “sp_setrepdbmode” in the “System Changes” chapter in the Adaptive Server Enterprise 15.0.3 New Features Guide.
