How to Get DataBase Name,Database Owner and Database size in a single Query ...

How to Get DataBase Name,Database Owner and Database size in a single Query ...

Nice Solution is Here

SELECT
A.NAME,
STR(CAST(SUM(SIZE) AS NUMERIC)*8192/1048576) AS 'DATA FILE(S) SIZE IN MB',
FLOOR(B.BACKUP_SIZE/1048576) AS 'BACKUP SIZE IN MB',
convert(sysname,DatabasePropertyEx(a.name,'Recovery')) as 'Recovery Mode'
,suser_sname(a.sid) as 'dbowner'
FROM (SELECT
MAX(BACKUP_START_DATE) AS BACKUP_START_DATE,
DATABASE_NAME
FROM MSDB..BACKUPSET
WHERE TYPE = 'D'
GROUP BY DATABASE_NAME) X
INNER JOIN MSDB..BACKUPSET B ON X.DATABASE_NAME = B.DATABASE_NAME
AND B.BACKUP_START_DATE = X.BACKUP_START_DATE
RIGHT OUTER JOIN MASTER..SYSDATABASES A ON A.NAME = B.DATABASE_NAME
INNER JOIN MASTER..SYSALTFILES C ON A.DBID = C.DBID
AND GROUPID != 0
WHERE A.DBID > 4
GROUP BY
A.NAME,
B.BACKUP_SIZE,
a.sid
ORDER BY A.NAME

	When your Dream turn to Dust, It's time to vacunm
From Pritesh Public Profile