MS SQL EM DB properties vs sp_spaceused

Hello everyone,
I am confused with the output of the DB properties page on Enterprise
Manager versus that of sp_spaceused for a particular database. I
can't understand how Enterprise Manager calculate for the Space
Available and can't correlate the value with what I am getting from
sp_spaceused.
Can anyone enlighten me on this?
Thanks.
Aramid
One thing to remember is that sp_spaceused includes the size of the transaction log file when it
calculates at the database level. Not something you normally want. Apart from that, make sure you
understand the extent concept so you understand difference between used reserved etc. That is a
prereq for understanding space usage information in SQL server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"aramid" <aramid@.hotmail.com> wrote in message news:in4ta1tem4954a6cg9prr4dlu19ejiqqs7@.4ax.com...
> Hello everyone,
> I am confused with the output of the DB properties page on Enterprise
> Manager versus that of sp_spaceused for a particular database. I
> can't understand how Enterprise Manager calculate for the Space
> Available and can't correlate the value with what I am getting from
> sp_spaceused.
> Can anyone enlighten me on this?
> Thanks.
> Aramid