For example
A changed a row but did not committed the changes. B reads the uncommitted data but his view of the data may be wrong so that is a Dirty Read.
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment
It is the same account you read, post and publish with — and you will come straight back to this page.
Rahul BansalPosted Jul 30, 2014, 12:15 AM
'SET TRANSACTION ISOLATION LEVEL REPEATABLE READ' just put this line above the Begin Transaction in the Stored Procedure...........For more info follow this link - http://msdn.microsoft.com/en-us/library/ms173763.aspx
Mukesh Kumar TiwariPosted Jul 29, 2014, 6:58 AM
how you can avoid this in ur application ??????
Rahul BansalPosted Jan 22, 2014, 12:31 AM
Sure, I will
Mahesh ChandPosted Jan 20, 2014, 11:33 PM
Good pointer Rahul. It will be nice to the solution of the same problem. Thanks!