>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

yes - although I'm not sure why you would use triggers to cascade inserts - so I guess I haven't run into that problem ...