SQL statement replication is applied to any DML statement that is executed in a batch, provided that:
The configuration allows SQL statement replication.
The DML statement does not conform to any of the conditions in “Exceptions to using SQL statement replication”.
In the example below, while executing the batch statement with delete and insert, only the first statement uses SQL statement replication. table2 uses traditional replication because table2 is not configured to use SQL statement replication:
create table table1 (c int, d char(5)) go create table table2 (c int, d char(5)) go insert table1 values (1, 'ABCDE') go 100 sp_setreptable table1, true go sp_setreptable table2, true go sp_setrepdefmode table1, 'UDI', 'on' go delete table1 where c=1 insert table2 select * from table1 go
