Triggers

There are some requirements when Adaptive Server uses SQL statement replication for DML statements within triggers.

The configuration allows SQL statement replication.
The DML statement does not conform to any of the conditions or exceptions to using SQL statement replication.

In the example below, when a delete statement is executed on table1, it is replicated using traditional replication. The delete executed on table2 via the trigger is replicated using SQL statement replication as the table is configured for SQL statement replication and the delete meets the conditions to be replicated as a statement:

create table table1 (c int, d char(5))
go
create table table2 (c int, d char(5))
go
sp_setreptable table1, true
go
sp_setreptable table2, true
go
insert table1 values (1,'one')
go
insert table2 values (2,'two')
go 100
sp_setrepdefmode table2, 'udi', 'on'
go
create trigger del_table1 on table1
for delete
as
begin
delete table2
end
go
delete table1 where c=1
go