BTW returning SCOPE_IDENTITY can be sent back as an OUTPUT parameter in 2k, and the new 2k5 (SQL Server) allows you to perform SELECT output.ID FROM ... statements.