Google Groups : microsoft.public.sqlserver.programming: "When picking up the newly inserted row make sure you use SCOPE_IDENTITY()"