Hi,
I found the following statement regarding IsolationLevels in MSDN:
"If changed during a transaction, the expected behavior of the server is to
apply the new locking level to all statements remaining."
(http://msdn.microsoft.com/library/de...-us/cpref/html
/frlrfsystemdataisolationlevelclasstopic.asp)
My question is: if I already have a SqlTransaction running, and want to
change the isolation level in the middle, how do I change it?
I found that the SqlTransaction.IsolationLevel property is ReadOnly.
Thanks for any help.