Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to find out diskspace

Author  Topic 

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2006-12-31 : 05:39:15
Hi all


How to find out the all available space on disk's using query analyser

I know xp_cmdshell dir *. gives present drive only is thire any other procedure
like Oracle SQL>!df -k


thanks in Advance
SreenivasaRao

SreenivasaRao
Bangalore,INDIA

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-12-31 : 05:59:56
You may try:

exec master..xp_fixeddrives

rockmoose
Go to Top of Page
   

- Advertisement -