Scope of SQL Statement Replication

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.