IT Community - Software Programming, Web Development and Technical Support

What are different transaction levels in SQLSERVER?

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?...


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 07-26-2007, 04:09 AM
oxygen oxygen is offline
D-Web Architect
 
Join Date: Jun 2007
Posts: 633
oxygen is on a distinguished road
Question What are different transaction levels in SQLSERVER?

What are different transaction levels in SQLSERVER?
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 07-26-2007, 04:16 AM
kingmaker kingmaker is offline
D-Web Genius
 
Join Date: Jun 2007
Posts: 882
kingmaker is on a distinguished road
Send a message via Yahoo to kingmaker
Default Re: What are different transaction levels in SQLSERVER?

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
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT -7. The time now is 04:14 AM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.

SEO by vBSEO 3.0.0