transaction isolation level

[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

 

[bishop]

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.