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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only