[font="Verdana"]
Landy_Ed (4/23/2010)
Thing to bear in mind with this is the new table is written to the default filegroup, does not recreate the indexes and reseeds any identity specification back to the default state on the table.
Notice IDENTITY and INDEX !!
CREATE TABLE TPOOP (
ID INT IDENTITY(1,1) UNIQUE NOT NULL,
REDO NUMERIC(8,3) NULL
);
GO
SELECT * INTO TPOOP2 FROM TPOOP
GO
SELECT * FROM TPOOP
SELECT * FROM TPOOP2
GO
EXEC sp_help 'TPOOP'
GO
EXEC sp_help 'TPOOP2'
GO
[/font]