0

I have a SQL (2005) server for which I need to monitor the amount of free disk space. It is not currently running a web server so a normal ASP/.Net monitor page won't work in this case. Is there any way that I can find the amount of free disk space on the server using only a SQL query?

Dave Forgac
  • 3,636

2 Answers2

1

Have you tried EXEC xp_fixeddrives ?

A decent list of stored procedures which aren't well documented here

sclarson
  • 3,714
1

Pretty good tip here (if you allow extended stored procedures)

Determine Free Disk Space in SQL Server 2000/2005

OldTroll
  • 1,736