DataSource Controls :: TableAdapter.Update Returning Incorrect Row Ids?

I'm lost as to where to look next. Here is a sample of what I'm doing:

[Code].... The related tableadapter insert statement was autogenerated by VS2008:

INSERT INTO [ProductCycleCountItem] ([ProductCycleCountLocationID], [ProductID], [CountOnly], [Status]) VALUES (@ProductCycleCountLocationID, @ProductID, @CountOnly, @Status);
SELECT id, ProductCycleCountLocationID, ProductID, CountOnly, Status FROM ProductCycleCountItem WHERE (id = SCOPE_IDENTITY())

With multiple users it's as if it was returning @@IDENTITY instead of SCOPE_IDENTITY(). The table will look like this:

id Location product

1 A 5321

2 A 8273

3 B 2827

4 A 1743
The returned dataset will look like this:

id Location Product

1 A 5321
2 A 8273
3 A 1743

Is it maybe a SQL Server (2005) setting that's incorrect?