sp_setrepdbmode

sp_setrepdbmode, 'on/off'

sp_setrepdbmode enables SQL statement replication at the database level for a specific DML operation. DML operations are designated as:

• U – update

• D – delete

• I – insert select

• S – select into

For example, to replicate delete statements as SQL statements and also enable replication of select into, enter:

sp_setrepdbmode pdb, 'DS', 'on'

When an user executes a delete on a table in database pdb, Adaptive Server logs additional information for SQL statement replication. The Replication Agent sends both individual log records, and the information needed by the Replication Server, to build the SQL statement.You can set SQL statement replication at the database level only when the database has been marked for replication by setting sp_setreptostandby to ALL or L1.