>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.
Insanity: Doing the same thing over and over and expecting different results.