>Hello all.
>
>What would cause SELECT @@identity to return an incorrect ID?
I have not worked with 6.5 (only 7.0 and 2000), but a trigger on the table in question that causes an INSERT on another table with and IDENTITY column. In that case, @@IDENTITY will give you the value from the 2nd table.
Chris McCandless
Red Sky Software