>How to shrink SQL database thru VFP ?

The trick I found somewhere involves three steps:

- detach database

sp_detach_db <your db name here>

- delete its logfile
- attach it as a single file:

sp_attach_single_file_db @dbname = '<your db name here>', 
   @physname = '<fullpath to>.mdf'

SQL will complain it's missing a logfile and will create a new one.

I've seen ten gig logfiles shrink to half a meg.