SELECT
SYS.DATABASES.NAME,
CONVERT(VARCHAR,SUM(SIZE)*8/1024)+' MB' AS 'DATABASE SIZE'
FROM SYS.DATABASES
JOIN SYS.MASTER_FILES
ON SYS.DATABASES.DATABASE_ID=SYS.MASTER_FILES.DATABASE_ID
GROUP BY SYS.DATABASES.NAME
ORDER BY SYS.DATABASES.NAME
No comments:
Post a Comment