In SQL server 2000 there are 4 isolation levels
Read uncommitted which can produce a dirty read, a repeatable read and a phantom read
Read committed which can produce a repeatable read and a phantom read
Repeatable read which can produce a phantom read
Serializable
What if I tell you that there is a 5th one, no it’s not snapshot isolation we are dealing with SQL Server 2000 here
The question is how do you set it and what is the (appropriate) name of this isolation level
I will post the answer on Memorial Day if no nobody answers by then
No comments:
Post a Comment