DECLARE @SQL NVARCHAR(MAX)

SELECT @SQL =

REPLACE(

CAST(

(

SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13) + CHAR(10) +

--PUT WHAT YOU WANT TO DO IN EACH DATABASE IN THIS BLOCK

----

'SELECT ' + CHAR(13) + CHAR(10) +

'DatabaseName = DB_NAME(), ' + CHAR(13) + CHAR(10) +

'a.FILEID, ' + CHAR(13) + CHAR(10) +

'[FILE_SIZE_MB] = CONVERT(DECIMAL(12, 2), ROUND(a.size / 128.000, 2)), ' + CHAR(13) + CHAR(10) +

'[SPACE_USED_MB] = CONVERT(DECIMAL(12, 2), ROUND(fileproperty(a.NAME, ' + CHAR(39) + 'SpaceUsed' + CHAR(39) +') / 128.000, 2)), ' + CHAR(13) + CHAR(10) +

'[FREE_SPACE_MB] = CONVERT(DECIMAL(12, 2), ROUND((a.size - fileproperty(a.NAME, ' + CHAR(39) + 'SpaceUsed' + CHAR(39) +')) / 128.000, 2)), ' + CHAR(13) + CHAR(10) +

'a.NAME, a.FILENAME ' + CHAR(13) + CHAR(10) +

'FROM dbo.sysfiles a;' + CHAR(13) + CHAR(10)

----

FROM

sys.databases

FOR XML PATH('')

) AS NVARCHAR(MAX)

),

'&#x 0D;',CHAR(13) + CHAR(10) --REMOVE THE SPACE ON THIS LINE BEFORE RUNNING

)

--SELECT @SQL

EXECUTE sp_executesql @SQL

Remove the space between x and 0 in the string in the code '&#x 0D;'

This will loop through the databases, getting file size, used space, free space for each DB file.