• I don't think theres a performance benefit of using the @@IDENTITY or SCOPE_IDENTITY() however if you are going to have multiple processes hitting the same tame then you really should be using SCOPE_IDENTITY() as its considered to be thread safe.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices