Kevin,
Try using the SQL Profiler to find out what commands are being sent to SQL Server. If it looks like a Delete/Insert combination are being sent, enable ODBC logging and check to see what's happening there.
Also be wary: if your table does not have a clustered index, SQL Server will decide where to place the new row. It will not always so up at the bottom of the table.
-Mike