Thanks Michael. I ended up using the @@IDENTITY before I got your reply. It has seemed to do the trick. Is this an older way of doing it vs. the method you laid out for me? I understand that @@IDENTITY works for the current session as long as that connection has not been closed. Is there added benefits/other that your method provides?