Insert column (at specific) location - can it be cancelled

[columbo2]

Foolishly I have inserted a column at a specific location on a large table (3.4million records).
In retrospect I should have added them to the end.

It's taking ages to do it.

Does anyone know...if I cancel it will my table be corrupted, or does it keep a store of the old table before it drops it and starts building the new table???

I'm thinking it may be quicker to cancel out and add the column to the end.

tahnks in advance

 

[mrdenny]

Yes you can kill it. The transaction will roll back.

What it's currently doing is making a copy of the data into a new table with the new schema. If you kill it this insert statement will simply kill cancled and rolled back. The rollback may take some time.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog