Learn how SQL statement replication applies
to DML statements in batch processing, triggers, and stored procedures.
Batch Processing
There are some requirements when you apply SQL statement replication to any DML statement that is executed in a batch.
Stored Procedures
The replication status of a stored procedure determines if DML statements within it are replicated as statements.
Triggers
There are some requirements when Adaptive Server uses SQL statement replication for DML statements within triggers.
Recompilation of Stored Procedures and Triggers
Stored procedures and triggers are automatically recompiled if SQL replication settings have changed from “off” to “on” between two successive executions of the stored procedure or trigger.
Cross-Database Transactions
A single transaction may affect tables from different databases. Modifications to tables located in a different database are logged in the databases that hold the tables.