Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Snapshot Isolation Level
- Thread starter net0zorro
- Start date
Not so far, but I agree it needs it. At the moment, the isolation levels are:-
1. Repeatable read (locks every row read in the cursor)
2. Read Stability (locks every row selected in the cursor)
3. Cursor Stability (locks the current row selected in the cursor)
4. Uncommitted Read (Doesn't lock any rows and reads uncommitted data).
1. Repeatable read (locks every row read in the cursor)
2. Read Stability (locks every row selected in the cursor)
3. Cursor Stability (locks the current row selected in the cursor)
4. Uncommitted Read (Doesn't lock any rows and reads uncommitted data).
- Status