This is a discussion on What are different transaction levels in SQLSERVER? within the Database Support forums, part of the Web Development category; What are different transaction levels in SQLSERVER?...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
| |||
| Transaction Isolation level decides how is one process isolated from other process. Using transaction levels you can implement locking in SQL SERVER. There are four transaction levels in SQL SERVER:- READ COMMITTED The shared lock is held for the duration of the transaction, meaning that no other transactions can change the data at the same time. Other transactions can insert and modify data in the same table, however, as long as it is not locked by the first transaction. READ UNCOMMITTED 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 This setting disallows dirty and non-repeatable reads. However, even though the locks are held on read data, 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 setting does not allow the insertion of new rows in the range that is locked; therefore, no phantoms are allowed. Following is the syntax for setting transaction level in SQL SERVER.SET TRANSACTION ISOLATION LEVEL SERIALIZABLE |
![]() |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| About Levels and Testing | devarajan.v | Software Testing | 35 | 02-14-2008 10:08 PM |
| Need Help: How to Get the currently running processes in sqlserver in .Net. | a.deeban | ASP and ASP.NET Programming | 1 | 08-16-2007 01:01 AM |
| MultiLanguageSupport-SQLSERVER | Murali | Database Support | 2 | 07-28-2007 03:28 AM |
| What are the Page level transaction and class level transaction? | H2o | Other Web Programming Languages | 1 | 07-20-2007 02:48 AM |
| Learn To Create Games Characters, Levels etc... - NOW! | theseokit | Game Development | 3 | 05-08-2007 04:18 PM |