Home Forums SQL Server 2005 Administering Checking for Available Disk Space (outside of SQL Server) RE: Checking for Available Disk Space (outside of SQL Server)

  • Thanks for all the responses.

    Question1 - Why is this so difficult or cumbersome to do using the operating system? I think this is a common task that is required by network engineers, dbas, etc. I would like to check disk space at the operating system level and send an email just in case SQL Server is not running or for my servers where SQL Server is not installed.

    (In my SQL Server Stored Procedure, I used xp_fixeddrives to get the drive and freespace information. Then I use OLE Automation to get the Total Size of each drive. This works fine and I can schedule it and send emails by creating a job and using sp_send_dbmail.)

    Question2 - can the xp_fixeddrives stored procedure and OLE Automation be used with SQL Server Express 2005? Can a Job be setup and scheduled from SQL Server Express 2005?

    Thanks in advance, Kevin