sp_setrepdbmode and sp_repstandby support SQL statement replication.
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, ASE logs additional information for SQL statement replication. The Mirror 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.
sp_reptostandby displays the SQL statement replication status at the database level. For example:
sp_reptostandby pdb go The replication status for database 'pdb' is 'ALL'. The replication mode for database 'pdb' is 'off'.
