hi, i am trying to shrink the data file (mdf). The db properties tab shows that there is 0mb free space.
It looks like it's been shrunk as far as it can go. 0MB free is never a good thing. Are you sure you don't mean you want it grow? If you did shrink the .mdf, be sure to rebuild your indexes because you've rendered them potentially useless.