Dear Mr.Perry Whittle Thank you for replying,

I executed the Script against the DB , i got the following

SpaceUsedMbs, SizeMBs, GrowthAllowed, MaxGrowthSize,Growth and FreeMBs result.But from this result how can i reduce the Size of MDF.

>Here SpaceUsedMbs, SizeMBs showing as same size (Ex:198Mb)

>MaxGrowthSize is showing as 198MB (Ex:)

>Growth is 16Mb (Ex)

>FreeMBs is showing 0

Can u pls Explain this as am not able to get the resolution to reduce the MDF size.