Isolation Level

Question

Post reply

Isolation Level

csoloway

Ten Centuries

Points: 1087
More actions
November 1, 2007 at 11:34 am

#119134

I've always read that isolation level has to be passed by the client connection. Is there any way to change the READ COMMITTED default other than a client connection?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

use the SET ISOLATION LEVEL TSQL to change the isolation level property to the one you desire.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

VaiydeyanathanVS Hall of Fame Points: 3053 More actions · Answer 2

READ UNCOMMITTED

Implements dirty read, or isolation level 0 locking, which means that no shared locks are issued and no exclusive locks are honored. When this option is set, it is possible to read uncommitted or dirty data; values in the data can be changed and rows can appear or disappear in the data set before the end of the transaction. This option has the same effect as setting NOLOCK on all tables in all SELECT statements in a transaction. This is the least restrictive of the four isolation levels.

The following example sets the TRANSACTION ISOLATION LEVEL for the session. For each Transact-SQL statement that follows, SQL Server holds all of the shared locks until the end of the transaction.

USE AdventureWorks;

GO

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;

GO

BEGIN TRANSACTION;

GO

SELECT *

FROM HumanResources.EmployeePayHistory;

GO

SELECT *

FROM HumanResources.Department;

GO

COMMIT TRANSACTION;

GO

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 3

You can read the article ISOLATION LEVEL articles in the link given below

http://www.sql-articles.com/

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com