Link to home
Start Free TrialLog in
Avatar of D B
D BFlag for United States of America

asked on

Transaction Processing - Using SQL Server 2000

Okay, I need to know just how much SQL can track for a rollback if neccessary. Here are the statements being performed, in order:

DROP TABLE table2
SP_RENAME 'table1', 'table2'
TRUNCATE TABLE 'table3'
BULK INSERT table3 FROM ...
DELETE table3 ...
UPDATE table3 ...
SELECT * INTO table1 FROM (SELCT * FROM table1 UNION ALL SELECT * FROM table3) A

I know there is no problem rolling back the TRUNCATE TABLE, DELETEs and UPDATEs, but what about the sp_rename or the BULK INSERT if I had an error in the last statement and needed to roll everything back?
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of D B

ASKER

I'll take your word for it.