D B
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER