Using SQL Server 2008, I have found that the database size can be obtained using
This procedure returns two tables:
database_name | database_size | unallocated space reserved | data | index_size | unused
I would like to create a query where the only output of the SQL call is the value returned for database_size. I do not want any extraneous output (no table headers, column names, etc).
Is there a simple way to do this?