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

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
 
 

Comments

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?

Leave a Comment

Please register or log in to leave a comment.