Subscribe to this blog
Briefcase
Print
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
Posted by anoop.myinbox on 10 January 2012
I want to perform bulk insert operation on a table . using BULK INSERT command in sql server. This bulk insert command enclosed in a Transaction.
BEGIN TRANSACTION
BULK INSERT ………
…………………….
COMMIT TRANSACTION
if the bulk insert operation is performed by more than one user at the same time . then there is a deadlock occurs. How can I avoid this situation. which type of isolation level is needed?