Re: ReadCommited means?

Tech-Archive recommends: Fix windows errors by optimizing your registry

ReadCommitted is the default isolation level for SQL Server. What it
means is that you can only read data that has been committed (saved)
to the database. The opposite is ReadUncommitted, which allows you to
access data that hasn't been saved, which results in a dirty read.
Here's the topic discussing the different enumerations:
http://msdn2.microsoft.com/en-us/library/system.data.isolationlevel.aspx
-mary

On Mon, 25 Jun 2007 10:29:29 +0800, "Ryan Liu" <RyanLiu_99@xxxxxxxxx>
wrote:

Hi,

For IsolationLevel.ReadCommitted, here "Committed" does not mean
trans.Commit(), it just means db has been updated. -- Is this right?

It means other thread/connection can read "my" data before I finish a
transaction.

Please clarify this.

Thanks a million1
R L


.

Relevant Pages

  • Re: change default isolation level on sql server 2005
    ... Have you actually set the database to Read_only? ... I believe SQL Server does some internal optimizations if it knows there will never be contention. ... I am also sure that there would be no way to change default isolation level ... "Kalen Delaney" wrote: ...
    (microsoft.public.sqlserver.programming)
  • Re: Setting Isolation Level
    ... >> I have an IDS 9.40FC6 database which receives queries from Sql Server>> 2000's OpenQuery functionality. ... >> user id to a given database need to have the isolation level set to ...
    (comp.databases.informix)
  • Re: change default isolation level on sql server 2005
    ... I am also sure that there would be no way to change default isolation level ... The database is only SELECT so that's why they would ... Our team would like to change default isolation level on sql server 2005 ... I see books online stating that the default isolation level is read ...
    (microsoft.public.sqlserver.programming)
  • change default isolation level on sql server 2005
    ... Our team would like to change default isolation level on sql server 2005 ... set TRANSACTION ISOLATION LEVEL on every stored procedures or set any data ... isolation level information on one database (not DBCC USEROPTIONS because it ...
    (microsoft.public.sqlserver.programming)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)