Transaction not commited rollback?

[Larry]

In VB 6, using ADO, SQL Server 2000

In my VB program I use the connection object (abc)
to begin a transaction.

abc.BeginTrans

I then, in my VB App, using ADO, execute multiple stored procedures
inserting records into temp tables ##Meetings,
reading them, and then finnaly executing (from my VB app
using ADO) as stored procedure that inserts records
into a non-temp table.

I then have a abc.CommitTrans

What if my VB program crashes before the
committrans is executed, I assume that the transaction
is rolled back, even though no explicit rollback
is issued, because my VB program has crashed.

Thank You for your help,

Laurence Nuttall
Programmer Analyst III
UCLA - Division of Continuing Education

[Erland Sommarskog]

Re: Transaction not commited rollback?

Larry (Bliff@Bliff.co m) writes:[color=blue]
> In VB 6, using ADO, SQL Server 2000
>
> In my VB program I use the connection object (abc)
> to begin a transaction.
>
> abc.BeginTrans
>
> I then, in my VB App, using ADO, execute multiple stored procedures
> inserting records into temp tables ##Meetings,
> reading them, and then finnaly executing (from my VB app
> using ADO) as stored procedure that inserts records
> into a non-temp table.
>
> I then have a abc.CommitTrans
>
> What if my VB program crashes before the
> committrans is executed, I assume that the transaction
> is rolled back, even though no explicit rollback
> is issued, because my VB program has crashed.[/color]

Yes.

If you want to verify - and this is a good exercise just try it. For
instance run the program from the VB debugger set a break point somewhere,
and then kill VB from the Task Manager. Now check that there is no data
which should not be there.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp