James Horsley (2/10/2009)
Actually original question (that I was answering) wasI have a table XYZ with 3 INT columns. There are 3000 records already in this table. Now I need a copy of this table with an identity column. What is the best way to do this?
No mention of "temporary".
And even then it depends what "temporary" means - if it is to "temporarily" have an IDENTITY on a column while I insert the true 200,000,000 records from a live database then you may well want to still have all data domain checks in place
Guess I got to the question after Steve changed it.