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.
AramidOne thing to remember is that sp_spaceused includes the size of the transact
ion log file when it
calculates at the database level. Not something you normally want. Apart fro
m that, make sure you
understand the extent concept so you understand difference between used rese
rved 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.c
om...
> 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