transaction isolation level

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top