Check Disk Size in SQL 2000

I was wondering if there is a way to check the total disk size using
SQL 2000.  There is a function to check how much is left, but havnt
found anything to check total size.

Hi

I am not sure what you mean by this! You can look at the output of sp_helpdb
or sp_helpfile to get the file sizes of the databases and you can do this fo
r
each database using a cursor! There are also SQL Server related permon
counters to monitor file sizes as well as perfmon counters to monitor disc
space usage. You can set an alert using perfmon if you disc usage reaches a
threshold. Alternatively you could use MOM to monitor your systems.

HTH

John

"cpatel1@gmail.com" wrote:

> I was wondering if there is a way to check the total disk size using
> SQL 2000.  There is a function to check how much is left, but havnt
> found anything to check total size.
>
>