Query to find out actual database size.?

Hi,
I would like to know that actual database size.
For eg.. I have a database DB1 on executing sp_databases,
the size I get is 50GB. But 40GB is actually used and rest
is free.
What query should I give to get actual database size.'
Thanks,
Sid.If you do an sp_spaceused you can see the unuesed and used space, so just
subtract the 2
Dylan
"Sid" <sid00@.rediffmail.com> wrote in message
news:016001c38ef7$a3cea100$a001280a@.phx.gbl...
> Hi,
> I would like to know that actual database size.
> For eg.. I have a database DB1 on executing sp_databases,
> the size I get is 50GB. But 40GB is actually used and rest
> is free.
> What query should I give to get actual database size.'
> Thanks,
> Sid.|||Thanks for the help.
Sid.
>--Original Message--
>If you do an sp_spaceused you can see the unuesed and
used space, so just
>subtract the 2
>Dylan
>"Sid" <sid00@.rediffmail.com> wrote in message
>news:016001c38ef7$a3cea100$a001280a@.phx.gbl...
>> Hi,
>> I would like to know that actual database size.
>> For eg.. I have a database DB1 on executing
sp_databases,
>> the size I get is 50GB. But 40GB is actually used and
rest
>> is free.
>> What query should I give to get actual database size.'
>> Thanks,
>> Sid.
>
>.
>