I want to know what is isolation levels in SQL Server.
Thank you.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Jul 19, 2012, 11:41 PM
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 NayakPosted Jul 19, 2012, 12:27 PM