Isolation Levels in SQL Server

Question

I want to know what is isolation levels in SQL Server. Thank you.

Jignesh Trivedi · Answer

hi, An isolation level that defines the degree how one transaction must be isolated from resource or data modifications made by other transactions. Isolation levels are described as which concurrency side-effects, such as dirty reads or phantom reads, are allowed. There are four type of Isolationlevel in SQL server Read uncommitted (lowest level) Read committed Repeatable read Serializable (highest level) Please refer http://msdn.microsoft.com/en-us/library/ms378149%28v=sql.90%29.aspx hope this will help you.

Satyapriya Nayak · Answer

Hi Vipendra, Please refer the below links http://www.gavindraper.co.uk/2012/02/18/sql-server-isolation-levels-by-example/, http://msdn.microsoft.com/en-us/library/aa213034%28v=sql.80%29.aspx, http://www.databasejournal.com/features/mssql/snapshot-isolation-level-in-sql-server-what-why-and-how-part-1.html, http://sqlserverpedia.com/wiki/Transaction_Isolation_Levels, Thanks

Isolation Levels in SQL Server

Answers (2)