SnapshotIsolation Level and Com

From: Jamie (anonymous_at_discussions.microsoft.com)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 06:58:25 -0800

Hi,

I am trying to run some tests using the new Snapshot
Isolation level in SQL Server 2005 and have a question.

Our application connects via COM+ and I believe that any
isolation levels set at database level will be overidden
by the isolation level set on the Com objects.

I was led to believe that it is possible to set the
Isolation level on the Com object on Windows 2003. If
so, where is it and what level is it?

I have looked at setting the Transaction Support level on
the Com+ component in question but I am not sure which
one to select. The following ones are listed: Any, Read
Committed, Read UnCommitted, Repeatable Read and
Serialized.

Am I looking in the right place? Any suggestions would
be gratefully recieved.

Jamie.

Relevant Pages

  • Re: SnapshotIsolation Level and Com
    ... > Isolation level in SQL Server 2005 and have a question. ... > isolation levels set at database level will be overidden ... Switching a database to snapshot isolation changes the behavior of Read ...
    (microsoft.public.sqlserver.server)
  • Re: isolation level is set to repeatable read
    ... Tibor, I am just suggesting that, if the isolation level is set from within ... SQL Server, then you will see the command in Profiler. ... > The only way to change this inside SQL Server is to use SET TRANSACTION ...
    (microsoft.public.sqlserver.server)
  • Re: CHAOS ISOLATION LEVEL
    ... > SQL Server does not support the CHAOS isolation level. ... > You should really troubleshoot the deadlocks. ... >> am processing this trough schedule DTS packages). ...
    (microsoft.public.sqlserver.dts)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... Just like I wouldn't recommend an Oracle customers snapshot isolation if their transaction must be serializable. ... This is also by far the most popular isolation level on DB2. ... SQL Server 2005, unless i'm gravely mistaken suppors two new twists. ... One of them is MVRC, the other is last committed without readers blocking writers. ...
    (comp.databases.oracle.server)
  • Re: Can SELECT block UPDATE?
    ... a select can block an update depending on the isolation level. ... Here is a link to the SQL Server 2000 BOL topic: ... Selecting in the READ UNCOMMITTED isolatino level, or using the NOLOCK hint, is the least restrictive locking, but as the notes explain, it has its downsides as well. ... I tried to find spid that was causing the block, ...
    (microsoft.public.sqlserver.server)
Loading