Isolation Levels in the Database Engine

The ISO standard defines the following isolation levels, all of which are supported by the SQL Server Database Engine:

*

Read uncommitted (the lowest level where transactions are isolated only enough to ensure that physically corrupt data is not read)
*

Read committed (Database Engine default level)
*

Repeatable read
*

Serializable (the highest level, where transactions are completely isolated from one another)