SELECT INTO loses all your original indexes, constraints etc - much better to copy the structure of original table by scripting it, add the Identity column, rename old table, build new one and copy rows across
James Horsley
Workflow Consulting Limited