Transactions between schema changes

Tech-Archive recommends: Fix windows errors by optimizing your registry

M_at_
Date: 03/04/04 

Date: Thu, 4 Mar 2004 09:36:32 -0600

I am running an application that makes multiple schema changes to a database
and I want to be able to rollback all changes if any failed. However, I have
tried using the ADO execute function and the ADO.Net transactions with no
success. Changes seem to be comitted as soon as the next change is made.

In ADO, I attempted to overcome this by using a shared connection and
starting the transaction when it was opened, but still each change seems to
commit the prior one although I am not executing a Commit until the end of
the series of changes.

Any ideas on how to make and then rollback multiple changes from an
application?

Thanks,

Matt

Relevant Pages

  • Hein is in the house :-) (was Re: Recommended HP COBOL way to exit a paragraph or perform early?
    ... commit or rollback. ... Committed but RMS just keeps getting better and better so is Repeatable Read ... node) the RMS Exec Mode Rundown handler will Rollback any outstanding ... transactions that a process may have if/when that particular process gets ...
    (comp.os.vms)
  • Re: Unit of work and Service dealing with XDocument
    ... transactions. ... public void Commit() { ... public void Rollback() { ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SP execution on rollback tran?
    ... A rollback without any saved name will rollback ALL transactions for that ... You should commit the inner transactions as soon as you are ...
    (microsoft.public.sqlserver.programming)
  • Transactions between schema changes
    ... I am running an application that makes multiple schema changes to a database ... and I want to be able to rollback all changes if any failed. ... tried using the ADO execute function and the ADO.Net transactions with no ... commit the prior one although I am not executing a Commit until the end of ...
    (microsoft.public.vb.database)
  • Re: transaction demarction
    ... do they mark something? ... a banking transaction that moves money from one bank account ... that involves database access and ends when you either COMMIT or ROLLBACK. ...
    (comp.lang.java.programmer)