Finding total size of the database in sql server

sp_spaceused Returns information about the total size of the database

Syntax:

Exec sp_spaceused

OUTPUT:

database_name                   database_size      unallocated space

-----------------------

myDB                                    3.00 MB            0.74 MB

reserved           data               index_size         unused

------------------ ------------------ ------------------ ------------------

1288 KB            584 KB             632 KB             72 KB

Thanks:)