Hi Doug,
You don't need to reindex SQL 7 indexes in the same sense that we have had to reindex FP/VFP indexes due to corruption. I've been running SQL 6.7/7.0 for several years and haven't had an index problem. There are tools in SQL for rebuilding indexes if needed. I don't think you will need to do it on a regular basis. HTH
>We are converting an existing VFP 6 application to client/server with SQL Server 7 on the backend. The current VFP 6 application has a PACK/REINDEX routine. Do we need something similar for the SQL Server data - do the indexes on the SQL Server data need to be maintained?
>
>Thanks,
>Doug
Bob Tracy
Never engage in a battle of wits if you're only half armed.