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.
"If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."