While researching, I found that
asked Apr 05 '10 at 06:51 PM in Default
Matt Whitfield ♦♦
Identity() can be used as a function when populating a table with integer values to create a table of dummy data for testing. It must be used via the "Select Into" method. After which you should go back and recreate your indexes.
answered Apr 05 '10 at 06:55 PM