Hello,

I'm using the following code implementing transactions:

Using trans1 As New Transactions.TransactionScope
       'Data manipulations here!
End using

How do I change the transaction isolation level?

Any help greatly appreciated!
Thanks in advance

Call a stored procedure- Use TSQL inside stored procs to set
transacation isolation levels
SET TRANSACTION ISOLATION LEVEL read uncommitted
BEGIN TRANSACTION
  -- Tsql code
END TRANSACTION

Hope this helps. "SQL Books online " is your friend.

Mark wrote:
Show quoteHide quote

Codesmith vs. Hand coding
Converting VB6 Structures to .NET
translating more stuff from C
Search DataRow Array
Problem using default xml namespace and selectsignlenode/selectnod
Reading specified format text from text file
IE clone. Any good pointer ?
Currency issue
not null statement
Storing Integer array in DB