Does Rollback rollback Temp Tables



In VB 6, Sql Server 2000,

If I have a transaction, the transaction is declared
in my VB program with the connection object conABC, as conABC.BeginTrans
and in that transaction I insert into a temp table, ##meetings and then later on do a rollback (from the vb program), conABC.RollbackTrans
does the temp table, ##meetings get rollbacked to?


Thanks in Advance,

Laurence Nuttall
Programmer Analyst III
UCLA - Division of Continuing Education


.



Relevant Pages

  • Re: Regarding EVALUATE TRUE
    ... with multiple 88-levels, and a numeric TEMP. ... for the WHEN's and their imperatives. ... WHEN NO-OUTPUT-TRAN ... continue with output transaction processing... ...
    (comp.lang.cobol)
  • Re: Transaction isolation levels
    ... SELECT 'X' INTO #TEMP ... locks the row in table TICKETS until the entire transaction has ... The lock taken out on TICKETS will be a shared lock ... that under the default isolation level will be released. ...
    (comp.databases.ms-sqlserver)
  • Regarding EVALUATE TRUE
    ... Usually I follow the Doc's prescription for whatever ails me in COBOL, ... with multiple 88-levels, and a numeric TEMP. ... for the WHEN's and their imperatives. ... continue with output transaction processing... ...
    (comp.lang.cobol)
  • Re: Problem trying insert data into a temp table via SP
    ... needs to load some data into a temp table. ... But throws another exception, -535 (Already in transaction), this ... fact that DB-Access is a separate session will kill you again - ...
    (comp.databases.informix)
  • Re: help: Timeout expired. The timeout period elapsed prior to completion of the operation or the se
    ... Actually we are putting records in a temp table which qualify according ... code fails very much even before transaction starts. ... unless really needed pls dont use lock hints as SQL ...
    (microsoft.public.sqlserver.server)