• It would be best to do a shrink to the target size that you want to get the database file to, and then run a reindex or reorganize on all tables.

    For the larger tables, you will probably want to run an index reorganize to prevent an reindex from expanding the data file again.

    You can use this script to shrink your database data file:

    Shrink DB File by Increment to Target Free Space

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80355