I just have a general question about identities:

Is it possible that when doing a SELECT IDENTITY_VAL_LOCAL inside a store procedure, that you could get the wrong identity returned?

For example, some does an insert into a row with an identity column at precisely the same time someone does an insert into the same table. Could USER A somehow get the identity that was created by USER B , and vice versa?

Any input would be helpful.

Thanks

The IDENTITY_VAL_LOCAL is only available locally within the level at which it was assigned. It is set to null whenever a COMMIT or ROLLBACK of a unit of work occurrred since the most recent INSERT statement of that assigned value. In other words they can't get to each other's values.