Database Properties

Hi,
From where can I get SpaceAvailableInMB and KB for a database for SQL
2000 and SQL 2005.
sp_spaceused gives the Size of the Database, Data Space Used, Index
Space Used.
SQL-DMO gives it.
Thanks
Prasad
Hi
CREATE table DriveTable (Drive varchar(10),[MB Free] int)
INSERT into Drivetable Exec xp_fixeddrives
SELECT * FROM DriveTable
"Prasad" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:eWfha44MGHA.2644@.TK2MSFTNGP10.phx.gbl...
> Hi,
> From where can I get SpaceAvailableInMB and KB for a database for SQL
> 2000 and SQL 2005.
> sp_spaceused gives the Size of the Database, Data Space Used, Index
> Space Used.
> SQL-DMO gives it.
> Thanks
> Prasad
>