>>I have been adding records to my test SQL Server table all day. Now I noticed that after I add a record (from VFP app), I go to Enterprise Manager, open the table, and select to Return All Rows, I don't see the new records. It looks like that PK value got stock on 9384. Yet, I can retrieve the newly added record from my VFP app.
>>
>>What am I missing? Or do I need to refresh something in the Enterprise Manager to see the new records?
>>
>>Thank you.
>
>I just noticed that the newly added records are somewhere in the middle of the table, not at the end. Why? In what order does Enterprise Manage show the records when you open a table?

Without a cluster order, none order exists.
have you defined a cluster primary key ?