FYI: MS still has not fixed @@IDENTITY with SP2(list inside)
Unbelievable!
Go here for a list of fixes in SP2.
<a href="http://support.microsoft.com/support/kb/articles/Q254/3/69.ASP">http://support.microsoft.com/support/kb/articles/Q254/3/69.ASP</a>