sql server data warehouse: How to check SQL 2K SP3 database size? How much space is
SQL database taking from the disk.

Please help.

Look up "SP_spaceused" in BOL.

--
Ray Higdon MCSE, MCDBA, CCNA
--
[quoted text, click to view]

Use the following system stored procedures.

1. sp_helpdb databasename

Example : sp_helpdb 'pubs'

2. Execute 'sp_spaceused' without any parameters, which
will show thw allocated space and free space for the
current database.

3. sp_spaceused objectname
This can be used to find the space occupied by a object,
freespace..

-Varad

[quoted text, click to view]