Identity Col and Transactions -- sql server programming

Nigel Rivett
8/22/2004 4:59:01 PM

Identity values aren't guaranteed to be consecutive or unique.

[quoted text, click to view]

Adam Machanic
8/22/2004 6:32:26 PM

Yes, that's by design; if that weren't the case, other transactions against
the same table at the same time would also have to be rolled back in order
to keep the sequential order.

[quoted text, click to view]

aussie rules
8/22/2004 11:30:34 PM

Hi,

I have a table with an Identity col, and it seems that if i insert a record,
but then role back the transaction, the identity value does not get
release/rolled backed as well.

Is this normal ?

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server programming

sql server programming : Identity Col and Transactions