Viewing post 1 (of 1 total)
The used formel "CONVERT(decimal(12, 2), 100 * (SpaceUsedMB / FileSizeMB)) AS [% Free]," gives %Used
For %Free the Code should be like this "CONVERT(decimal(12, 2), 100- (100 * (SpaceUsedMB / FileSizeMB)))...
November 11, 2014 at 5:00 am
#1757654