Re: XA and NON-XA Transactions

sp_cursoropen can be part of both transaction types.

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:3372D66E-E3A9-4CFB-A2D0-17FE2521BF7B@xxxxxxxxxxxxxxxx
> 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

  • 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)
  • Re: commit work not working?
    ... Because he is using straight sql, ... The transaction is made up of the statements that occur ... locks the stock table, updates rows in the stock table ... The database server must perform this sequence of operations either ...
    (comp.databases.informix)
  • Re: Locking and Delay in a Bottleneck
    ... that should avoid the gap issue on rollback, ... SQL Server MVP ... the saving transaction, this journal voucher is having a header table ... number in a table whereupon you commit. ...
    (microsoft.public.sqlserver.programming)
  • Re: Handling Script Timeout when invoking ActiveX Object involving ADODB from ASP2.0 pages- SQL Clie
    ... The SQL Client Network Utility on the remote SQL Server 2000 SP3a on Windows ... > This is an example of an Aborted Transaction. ...
    (microsoft.public.sqlserver.clients)
Loading