Since triggers are fired by data modification statements (like insert), all triggers execute at either the transaction’s isolation level or isolation level 1, whichever is higher. So, if a trigger fires in a transaction at level 0, Adaptive Server sets the trigger’s isolation level to 1 before executing its first statement.
