Guaranteed consecutive identity values - microsoft.public.sqlserver.programming

Message from discussion Guaranteed consecutive identity values

From: "Michael Abraham" <mabraha...@newsgroup.nospam>
Subject: Guaranteed consecutive identity values
Date: Fri, 10 Feb 2006 09:48:24 -0500
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
Message-ID: <epPcMElLGHA.4064@TK2MSFTNGP10.phx.gbl>
Newsgroups: microsoft.public.sqlserver.programming
NNTP-Posting-Host: gw.monitor.com 12.151.151.3
Path: g2news1.google.com!news3.google.com!newshub.sdsu.edu!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl

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