469,632 Members | 1,698 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.

SET TRANSACTION ISOLATION LEVEL What is it all about?

Hi Everyone I have a question I was told to use this statements each time I create a stored procedure (see below) but they couldn't explain me what's the use. I would appreciate some basic explanations :)


SET TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED
BEGIN TRANSACTION


COMMIT TRANSACTION

Many thanks in advance
Emil
Jan 4 '08 #1
1 1489
deepuv04
227 Expert 100+
Hi Everyone I have a question I was told to use this statements each time I create a stored procedure (see below) but they couldn't explain me what's the use. I would appreciate some basic explanations :)


SET TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED
BEGIN TRANSACTION


COMMIT TRANSACTION

Many thanks in advance
Emil
Isolatiion Level Describes how the isolation levels work with locking to ensure that users can access data concurrently.

i think u know about locking mechanism, in customizing locking transaction silation level is used

for more information visit the link

http://msdn2.microsoft.com/en-us/library/ms171813.aspx


thanks
Jan 4 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

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
By using this site, you agree to our Privacy Policy and Terms of Use.