Enable SQL Statement Replication

sp_setrepdefmode 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