A recent Channel9 post talked about the MS Enterprise Library incorrectly using @@IDENTITY after INSERT. The post suggested a DBA would have done better job. For me, it is essential that you need to have multi-user/session/thread in mind when writing/reviewing code.