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
25 16 25 9 16 25 4 9 16 25 1 4 9 16 25

Connect a Software Application to a Database Backend Acquire the knowledge and develop the skills needed to prototype an end user application using a rapid application dev

Question: (a) List three advantages of binding data to controls. (b) The Repeater control uses templates to control formatting. Define the five types of templates supporte

How many types of assemblies are there? Private, Public/Shared, Satellite. A private assembly is normally used by a one application, and is stored in the application's director

What are advantages of SQL 2000 over SQl 7.0? 1)User-Defined Functions: The User-Defined Functions (UDFs) -- one or moreTransact-SQL statements may be used to encapsulate the

What is Asynchronous One-Way Calls The One-way calls are a different from the asynchronous calls by the execution angle that the .NET Framework does not assure their execution.

Problem: (a) (i) Using a diagram, illustrate the basic process in an ASP.NET Architecture involving at least five objects. (ii) List two methods and two collections

How can you make a simple harmonic motion in visual basic 2010 where you will ask an input to the user and your output will be a moving pendulum and a graph. Also the displacement

What's difference between Datagrid, Datalist and repeater? The Datalist ,Datagrid, and Repeater are all ASP.NET data Web controls. They have many things in common such as Da

Xlsx/Csv File Reader Need C# MVC coder that will do the following- Take a filepath for an online xlsx, xls or csv file (must be able to handle each of these formats) as well