Don't forget that only one table can have identity_insert set on at a time, and that the user account running set identity_insert must have db_owner permissions.