I was able to run a reindex and an intigrity check on the database and I can access the data but I'm still getting update conflicts coming from VFP on one particular table. I have several databases with the same table that are not giving me this problem.
You can check fragmentation with DBCC SHOWCONTIG(). DBCC SHOWCONTIG scanning 'continuityorderheader' table... Table: 'continuityorderheader' (549576996); index ID: 0, database ID: 13 TABLE level scan performed. - Pages Scanned................................: 2409 - Extents Scanned..............................: 304 - Extent Switches..............................: 303 - Avg. Pages per Extent........................: 7.9 - Scan Density [Best Count:Actual Count].......: 99.34% [302:304] - Extent Scan Fragmentation ...................: 0.66% - Avg. Bytes Free per Page.....................: 80.7 - Avg. Page Density (full).....................: 99.00% DBCC execution completed. If DBCC printed error messages, contact your system administrator.
What happens when you run a query from QA with the results in TEXT mode (NOT grid)? It works fine now (grid or no grid).
What does DBCC CHECKTABLE() return? DBCC results for 'continuityorderheader'. There are 101094 rows in 2409 pages for object 'continuityorderheader'. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I'm gonna try a few things in VFP out of the application to see if I can reproduce the results in the command window - Be Right Back!!
