Re: SnapshotIsolation Level and Com

From: wei xiao (weix_at_online.microsoft.com)
Date: 02/02/05 

Date: Wed, 2 Feb 2005 02:17:06 -0800

COM+ often uses distributed transaction to talk with SQL Server. As a new
feature in SQL Server 2005, snapshot isolation is not supported in a
distributed transaction.

We recommend that you use "read committed snapshot isolation" instead of
"snapshot isolation" in COM+. Please see books online and the following
white paper for more details:
http://www.microsoft.com/technet/prodtechnol/sql/2005/SQL05B.mspx 

-- 
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jamie" <anonymous@discussions.microsoft.com> wrote in message 
news:2ef301c5086e$7aebb6a0$a401280a@phx.gbl...
> 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: Transaction Isolation Level
    ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)
  • Re: Transaction Isolation Level
    ... the isolation level you should use is snapshot isolation. ... You may see different last names for the same employee ID if the query ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: snapshot isolation level
    ... the ability to set this really depends on the Provider. ... pre-2005 SQL Server did not have snapshot isolation: ... isolation, so there is no relevant enum. ... Is there a way to use snapshot isolation level in an old (prior ...
    (microsoft.public.data.ado)
  • Re: SET TRANSACTION ISOLATION LEVEL
    ... If, I set the isolation in the sp, will sql server use this isolation that ... But you can modify the procedure and set the isolation level from inside the procedure so ... > that you counter-act the client setting. ...
    (microsoft.public.sqlserver.server)
  • Re: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)