Yep - you need to enable Identity insert (look at BOL for more detail). This allows you to copy the identities from one table to another. Essentially it forces a...
Our whole design approach with our web applications is based on reducing round-trips and minimising the size of data being sent back and forth. We have come up with a number...