>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.