Available Space at my database

[Susan]

Hi, I work on SQL Server 6.5,
and I want to make a documentation about available space of my databases.
So, I must know how many databases space used everyday ?

If somebody know how to get this available space or how to make this script.
I hope you want to tell me about this.
Thanks you so much for your cooperation.

[Ray Miao]

Try sp_spaceused.


------------
Susan at 1/9/2002 11:28:18 PM

Hi, I work on SQL Server 6.5,
and I want to make a documentation about available space of my databases.
So, I must know how many databases space used everyday ?

If somebody know how to get this available space or how to make this script.
I hope you want to tell me about this.
Thanks you so much for your cooperation.

[David]

I created a web page that runs from my web server that polls the database and displays:

Disk Free Space
Database Size
Database % Free
Data DEVICE % Free
Log DEVICE % Free

All data comes from available stored procs in sql

xp_fixeddrives
sp_helpdb
dbcc sqlperf(logspace)
sp_spaceused

Cheers,

Davy
------------
Susan at 1/9/2002 11:28:18 PM

Hi, I work on SQL Server 6.5,
and I want to make a documentation about available space of my databases.
So, I must know how many databases space used everyday ?

If somebody know how to get this available space or how to make this script.
I hope you want to tell me about this.
Thanks you so much for your cooperation.