Home Forums Article Discussions Article Discussions by Author Discuss content posted by Trevor Makoni Get database size, used space, free space RE: Get database size, used space, free space
mario.hochhaus
Grasshopper
Points: 17
More actions
November 11, 2014 at 5:00 am
#1757654
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))) AS [% Free],"