Repeatable reads  Changing the isolation level for a query

Chapter 20: Transactions: Maintaining Data Consistency and Recovery

Finding the status of the current isolation level

The global variable @@isolation contains the current isolation level of your Transact-SQL session. Querying @@isolation returns the value of the active level (0, 1, or 3). For example:

select @@isolation

--------
       1
 
(1 row affected)



Copyright © 2005. Sybase Inc. All rights reserved. Changing the isolation level for a query

View this book as PDF