DECLARE @SQL NVARCHAR(MAX)

		SELECT @SQL = REPLACE(
							CAST(
									(
										SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13) + CHAR(10) +
										'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 0 D ;',CHAR(13) + CHAR(10)
						)
		--SELECT @SQL
		EXECUTE sp_executesql @SQL

DECLARE @SQL NVARCHAR(MAX)

		SELECT @SQL = REPLACE(
							CAST(
									(
										SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13) + CHAR(10) +
										'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)
							),
						'
',CHAR(13) + CHAR(10)
						)
		print @SQL
		EXECUTE sp_executesql @SQL

dbcc sqlperf('LOGSPACE')