If you're using SQL Server 2000 try returning:
Code:
SELECT SCOPE_IDENTITY()
instead as @@IDENTITY is global and will not necessarily return you the ID of the table you just inserted into (especially if you have triggers on that table that insert into another table!)