>>In my VFP application that works with VFP database I have an item on the main menu to reindex all tables (using SDT). Now as I am moving to SQL Server I am wondering, is it a common practice to have the same item in the VFP application menu? That is, to have the application to reindex SQL Server tables? Or this is more commonly done by a DBA?
>>
>>TIA.
>
>
>This is done by Maintenance plans defied by you or DBAs.
>If you (DBA) can't define such plan (because of Express editions of SQL Server) you could use DBCC commands.
Did you mean running the SP to reindex from the application? What do you mean by DBCC commands?
If it's not broken, fix it until it is.
My Blog