Category Archives: sp_msforeachDB

Use FILEPROPERTY to find free space in all the database

Posted on August 26, 2015 by Prashanth Jayaram

The use of SpaceUsed property of the FILEPROPERTY function gives how much space is used also we can derive lot of other attributes of it such as free space and percentage of free space. For other versions of SQL you … Continue reading →

Posted in databases_files, FileProperty, sp_msforeachDB, SQL, sysfiles | Tagged , | Leave a comment