Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2009

Transaction isolation level

Transaction isolation level:
 
1. Uncommitted Read (NoLock)
2. Committed Read (blocking)
3. Repeatable Read (phantom)
4. Snapshot  (no blocking)
5. Serializable (no blocking)
 
Dirty Read:(DR)
Non Repeatable Read:(NRR)
Phantom:(P)
 
Great link:
 
Thanks
Vinay
 
 

Read more

1 comments, 582 reads

Posted in Vinay Thakur on 19 May 2009