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

  • 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],"