>>>>>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?
>>
>>
>>sp_MSForEachTable :-)
>>

>>EXEC YourDBName..sp_MSforeachtable 'DBCC DBREINDEX(''?'')'
>>

>
>Speaking about Maintenance plan. Who makes it (if such term can apply to it)? the DBA or developer?

DBA of course.
That is their job to Maintenance the databases.