> If I do a INSERT INTO <table> SELECT ... and <table> has an identity
> column with an increment equal to 1, does SQL/Server 2000 and/or
> SQL/Server 2005 guarantee that the identity values generated for a single
> successful INSERT of this type will be consecutive.  So if I do an INSERT
> INTO ... SELECT which inserts, for example, 17 rows, am I guaranteed that
> the identity values assigned will be N, N+1, N+2, ..., N+16.

> That is, is it guaranteed that simultaneous INSERTs on other connections
> will not interrupt the sequence of identity values assigned.

> Thanks,

> Mike