RE: [DUG]: [DUG-DB]: Unique IDs

[Paul Ritchie]

> any IDs generated after this point may duplicate an ID 
> generated during the rolled back transaction. 

I don't think so.  From Books Online under the @@identity entry:

"The @@IDENTITY value does not revert to a previous setting if the INSERT or
SELECT INTO statement or bulk copy fails, or if the transaction is rolled
back."

It goes on further about accomplishing consecutive IDs in this situation,
but I would be more tempted to add a seperate timestamp or datetime column
containing the time the row was inserted to achieve this.

Paul Ritchie.
---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"