Re: XA and NON-XA Transactions

Ok then..all the DTC transactions are XA transactions and all the sp_Cursoropen
statements are non-xa transactions am i right,because i wanted to see where
there
are more xa or non-xa transactions coming to the database i wanted to change
the selctmode to direct instead of cursor ..just to try but the vendor of
one particular app says it wouldn't work for xa datasources so i wanted to
see if there
are more xa or non-xa transactions so that if we change for non-xa.it will
make the difference.

Thanks Very Much..



"Gert E.R. Drapers" wrote:

> If it is an XA transaction there will be a distributed transaction started,
> so if you include event 19, DTCTransaction with columns for EventSubClass,
> TextData and BinaryData, you will see the distributed transaction events,
> which if they come from a JDBC clients are XA events. You will not see the
> XA info inside SQL, since SQL does not understand XA directly, it gets
> mapped using xaswitch in to a MS-DTC transaction, in to which SQL Server
> will enlist.
>
> GertD@xxxxxxxxxx
>
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> You assume all risk for your use.
> Copyright © SQLDev.Net 1991-2005 All rights reserved.
>
> "chinn" <chinn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:B9EF0F66-A379-4073-8E4E-08CC61861D81@xxxxxxxxxxxxxxxx
> > Hello,
> >
> > In a profiler how to find out if a particular transaction is an XA
> > transaction or an non-XA transaction.
> >
> > Thanks In Advnace!
> >
>
>
>
.

Relevant Pages

  • Detect if Distributed Transaction is used or just SQL 2005 internal transaction?
    ... tells me the distributed transaction is not used yet but right after the ... connection string to SqlHelper.ExecuteNonQueryAND this works ... SQL); ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: XA and NON-XA Transactions
    ... If it is an XA transaction there will be a distributed transaction started, ... TextData and BinaryData, you will see the distributed transaction events, ... XA info inside SQL, since SQL does not understand XA directly, it gets ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: XA and NON-XA Transactions
    ... sp_cursoropen can be part of both transaction types. ... > statements are non-xa transactions am i right,because i wanted to see ... >> XA info inside SQL, since SQL does not understand XA directly, it gets ... >> Please reply only to the newsgroups. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Asynchronous Stored Procedure Never Returns - Help?
    ... If you have the Sql Server 2000 or 2005 docs they are thorough and can be ... for Transaction SQL Reference from the drop-down or select a keyword from ... your query in Query Analyzer or Sql Server Management Studio, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: DB API 2.0 and transactions
    ... CURRENT_TIMESTAMP within a transaction should be the same. ... manadate that CURRENT_TIMESTAMP in only evaluated once in each SQL ... transaction-initiating SQL statement takes place. ... src = self.__cnx.source ...
    (comp.lang.python)
Loading