Stored procedures and isolation levels  Compliance with SQL standards

Chapter 20: Transactions: Maintaining Data Consistency and Recovery

Triggers and isolation levels

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.





Copyright © 2005. Sybase Inc. All rights reserved. Compliance with SQL standards

View this book as PDF