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 2005 Forums
 SQL Server Administration (2005)
 Need to check available space on a DB's drive..

Author  Topic 

Jim Beam
Posting Yak Master

137 Posts

Posted - 2010-09-22 : 10:38:05
Last I remember it was XP_Fixeddisk, but that's not it exactly..

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-09-22 : 11:08:39
Yep, that's it. You can also use xp_cmdshell to run a "dir" command and parse the free space from the results.
Go to Top of Page

steel
Posting Yak Master

107 Posts

Posted - 2010-09-25 : 11:44:47
Hi You can also use xp_fixeddrives.
Go to Top of Page
   

- Advertisement -