Hi,

I have a VFP5/SQL server 4.2 system. We will be moving to SQL Server 7 in a few months, but I'll tell what we currently do in SQL Server 4.2.

We run a batch file that runs every Sunday night. The batch file calls a sql file that drops the index on every table and rebuilds the index and then does a recompile of all the stored procedures and triggers used by the table.

I've included a portion from the sql file.

Good Luck,

Paul

GO
/****************************************************************************/
/****************************************************************************/
PRINT ''
PRINT 'Dropping Index: ADDR_USE_TBL_KEY on Table: dbo.ADDR_USE_TBL'
PRINT ''
DROP INDEX ADDR_USE_TBL.ADDR_USE_TBL_KEY
GO
PRINT ''
PRINT 'Creating Index: ADDR_USE_TBL_KEY on Table: dbo.ADDR_USE_TBL'
PRINT ''
CREATE UNIQUE CLUSTERED INDEX ADDR_USE_TBL_KEY ON ADDR_USE_TBL
( ADDR_USE_CODE )
WITH FILLFACTOR = 70
GO
sp_recompile ADDR_USE_TBL
GO
/****************************************************************************/
/****************************************************************************/


>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