SELECT database_id,CONVERT(VARCHAR(25), DB.name) AS dbName,(SELECT SUM((size*8)/1024) FROM sys.master_files WHERE DB_NAME(database_id) = db.name AND type_desc = 'rows') DATA_MB,(SELECT SUM((size*8)/1024) FROM sys.master_files WHERE DB_NAME(database_id) = db.name AND type_desc = 'log') AS [Log MB] FROM sys.databases DBWHERE name in (select name from sys.databases)
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: