WE have the next problem.

When a SP retun a status diferent of 0 and the SP is calling from a trigger
then the transaction is rollback and do nothing. If the return status si 0
the everything it's ok.

For example>

create table x (a int)
create proc xx as return 2
create trigger txx on xx for insert,update as exec xx


insert x values (1)

in Sybase the result was a

in Adaptive Server 11.5 for NT the result was


anyone know if it's a feature, a changed or a bug... and if it's a feature
then how can we disability this.


Ing. Juan Alvarado