>WOW, when I go into sql Enterprise manager and select the table then hit Properties it shows 1990 records yet in a remote view foxpro shows 2000 records and when I Open all records in Enterprise manage, it has 200 records.
>
>
>Is the Properties in Enterprise manager frequently WRONG????

Sounds like you need to go into SQL Query Analyzer and run

update statistics your_table

The statistics are what SQL Server uses in the Properties, so if they're off, they are reported wrong. This could also be the problem between SQL and VFP [but no promises there :)]
Also, in SQL Server, if you set the auto update statistics property on for the database, this should be less of a problem in the future.