>How would you know which was the record ou had just added on the second connection? Would you need another key made up from the other fields?
Yes, you'd need some sort of candidate key.
>In what circumstances does @@IDENTITY not work? - I ask as its been ages now since I was lucky enough to do anything with SQL Server!
It's been so long since I tried it, Ian, I can't recall the circumstances.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05