You noted that #1 is false. It is my understanding that SELECT @@Identity contains the last IDENTITY value assigned -- regardless of the table, therefore, if records are inserted into tables based on insert triggers in SQL, you would be getting back the wrong value??

Thanks,
Doug