Andy,

Thank you very much for pointing out the @@IDENTITY. It certainly works very well. However, that's when I take off the triggers on the table.

When the triggers are in...