Explain different isolation levels

Posted by

To view Verified answers click on the button below.

An isolation level determines the degree of isolation of data between concurrent
transactions. The default SQL Server isolation level is Read Committed. Here are the other
isolation levels (in the ascending order of isolation): Read Uncommitted, Read Committed,
Repeatable Read, Serializable. See SQL Server books online for an explanation of the
isolation levels. Be sure to read about SET TRANSACTION ISOLATION LEVEL, which lets
you customize the isolation level at the connection level.