That's not true. While @@Identity will give you bad results if you insert rows into tables that have triggers that insert rows into other tables with identity fields, the problem you described is not a problem.
@@Identity is scoped to the current connection so insertions made on connections made by other users (even in the same table) will not affect your result.
>PMFJI but, you need to be careful when reading the PK in a separate call from the insert statement. @@IDENTITY returns the last inserted identity value. If several users are inserting records at the same time or several records are being added you may not get the right PK value.
>
>I know this doesn't answer your question but just wanted to point this out. I do not use RV's myself.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao