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

then

insert x values (1)

in Sybase 11.0.2.2 the result was a
----
1

in Adaptive Server 11.5 for NT the result was

a
-----

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

TIA

Ing. Juan Alvarado