RE: Transactions commit during command timeout

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 12/23/04 

Date: Thu, 23 Dec 2004 05:54:45 GMT

Hi,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to know why the SQL server
sends a timeout error and the transaction is still committed. If there is
any misunderstanding, please feel free to let me know.

As far as I know, when we start a new transaction with BEGIN TRAN and
execute some SQL commands, for example, insert, the transaction will not be
rolled back until you call ROLLBACK TRAN explicitly. However, the record
will be inserted, but COMMIT TRAN will not be executed.

In your last post, you mentioned that the transaction has been committed.
Do you mean that you saw COMMIT TRAN in the SQL Profiler or you just saw
that records have been inserted?

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • Re: SqlTransaction problem???
    ... connection and transaction objects directly... ... Are you perhaps doing multiple transactional sql calls on different ... Commit Tran ...
    (microsoft.public.dotnet.languages.csharp)
  • Newbie help with binary fields and locks
    ... If I were not doing this in a SQL database, I would set up an array of bits and simply look for the first zero bit. ... and a column to indicate the length of the varbinary field (which is really my maximum number of generateable strings). ... I am assuming that I can execute a Begin Transaction with the SqlCommand.ExecuteNonQuery method. ...
    (microsoft.public.sqlserver.server)
  • Re: Any way to get an execution trace out of Access?
    ... If you're doing something like assigning open tasks to users, you may need to run the sql in a transaction with serial isolation. ... The problem appeared to be that the Select subquery would execute "simulataneously" for multiple users, so even if the Update portion were properly controlled, 2 users could be assigned the same task. ... By increasing the transaction isolation level, the Select subquery was forced to be part of the Update transaction. ...
    (microsoft.public.access.formscoding)
  • Re: Urgent problem: Any help greatly appreciated
    ... Can you combine those store procedures to derive a new one in your SQL ... > I am trying to execute a number of SQL stored procedures in a single ... > transaction. ... > executing DataAccessProvider.executeBatchTransaction(ArrayList cmds", ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Urgent problem: Any help greatly appreciated
    ... Can you combine those store procedures to derive a new one in your SQL ... > I am trying to execute a number of SQL stored procedures in a single ... > transaction. ... > executing DataAccessProvider.executeBatchTransaction(ArrayList cmds", ...
    (microsoft.public.dotnet.framework.adonet)