I am using the MpmTransaction object to keep 4 different updates to the database together. The 2nd, 3rd and 4th updates need to check to see if the first update has been completed. In version 1.2.3 this worked fine, but upgrading to version 2.0.1 and .NET 2.0 the 2nd, 3rd and 4th stored procedures can not see the record inserted in the first record. I have tried BeginTransaction(IsolationLevel.ReadUncommitted), but this does not seem to work even though the help for it says "A dirty read is possible, meaning that no shared locks are issued and no exclusive locks are honored."
I am using SQL Server 2000 SP4.
Log in to post a comment.