Michael Abraham <mabraha...@newsgroup.nospam>

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