>It helps for scheduled general maintenance of database and automated backup which will be difficult to set for normal user. If done through VFP I could give them easy basic screens to set it up.
1. Create a maintenance plan using SQL Server Maintenance Plan Wizard
2. Analyze it and figure out how to create it using T-SQL
3. Code it in VFP using SPT or SQL DMO
--sb--