Different transaction levels in sql server, DOT NET Programming

What are different transaction levels in SQL SERVER?

The Transaction Isolation level decides how is the one process isolated from theother process. Using the transaction levels you can implement locking in the SQL SERVER.

There are 4 transaction levels in SQL SERVER as shown below:-

READ COMMITTED:

In this the shared lock is held for the duration of the transaction, means that no other transactions can modify the data at the same time. The Other transactions can insert and change data in the same table, however, as long as it is not locked by the first transaction.

READ UNCOMMITTED:

In this no shared locks and no exclusive locks are honored. This is the least restrictive isolation level resulting in the best concurrency but the least data integrity.

REPEATABLE READ:

In this the setting disallows dirty and non-repeatable reads. However, even though the locks are held on read data, the new rows can still be inserted in the table, and will subsequently be interpreted by the transaction.

SERIALIZABLE:

This is the most restrictive setting holding shared locks on the range of data. ThisĀ  does not allow the insertion of new rows in the range that is locked; hence, no phantoms are allowed.

Posted Date: 9/24/2012 4:21:24 AM | Location : United States







Related Discussions:- Different transaction levels in sql server, Assignment Help, Ask Question on Different transaction levels in sql server, Get Answer, Expert's Help, Different transaction levels in sql server Discussions

Write discussion on Different transaction levels in sql server
Your posts are moderated
Related Questions
Question: (a) The ObjectDataSource control is an alternative design approach to using AccessDataSource or SqlDataSource controls. Explain and illustrate how an ObjectDataSourc

What is CAR (Causal Analysis and Resolution)? The basic purpose of the CAR is to analyze all the problems, defects, and good practices/positive triggers in projects, perform a

Project Description: Program or Fan Page Poster for facebook fan pages. Major task of this program would be posting pictures on your facebook fan page from other users fan pa

Explain the concept of Bookmarks in WF 4.0. In WF 4.0, a bookmark is a mechanism that enables an activity to wait for an input without interrupting a workflow thread. When an a

What are the different types of triggers in SQl There are 2 types of triggers in the SQL server 2000 :- 1) INSTEAD OF triggers: The INSTEAD OF triggers fire in place of

Explain the concept of destructor? A destructor is a special method for a class and is requested automatically when an object is finally destroyed. The name of the destructor i

TASK - DESIGN ALGORITHM You are required to design a suitable solution algorithm by using either structured chart, pseudocode or flowchart. This diagram should clarify the proce

What are tuples? Tuple is a fixed-size collection that can have elements of either similar or different data types. Same to arrays, a user must have to specify the size of a tu

I need Isometric Exploration Tablet Game I am endeavoring to build an 2D tile-based isometric game, primarily for Android and iOS tablet devices. It will be built in Unity 3d v4

What is DISCO? The Web Service Description Language (WSDL) is a W3C specification which defines the XML grammar for describing the Web Services.XML grammar describes details li