SET TRANSACTION ISOLATION LEVEL What is it all about?

[emsik1001]

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

[deepuv04]

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