SELECT @@IDENTITY on the same connection.

BOb


>Is there an easy way to return a key value generated from a field incremented with identity right after an insert of a single record?
>I've ben using " Select max(identity value) from table" right after an insert and wory about possible updates happening before I can get max() retuned.
>
>Thanks
>Jeff