Are you actually dropping the original table?
In the "Select into" you get all the data. As long as you don't drop the original table, if you want to back off the the import, you would just do:
TRUNCATE TABLE TableName
GO
INSERT INTO TableName
SELECT *
FROM NewTableName
GO
The indexes, keys etc. should automattically regenerate ont the re-isnert.
If you want to be absolutely sure then you have to script the table and indexes throught the enterprise mansger or from the query anlyzer, change them all to the NewTableName
run the scripts and then do:
INSERT INTO NewTableName
SELECT *
FROM TableName
GO
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.