469,632 Members | 1,600 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,632 developers. It's quick & easy.

transaction isolation level

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
Aug 23 '06 #1
1 1978
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:
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
Aug 23 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Eric Porter | last post: by
3 posts views Thread by joshsackett | last post: by
2 posts views Thread by Christian Stooker | last post: by
6 posts views Thread by Bob Stearns | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.