SQL Server Performance Forum – Threads Archive

sql determining free disk space?

I have an app deployed with MSDE for very complex analysis but potentially running in a limited standalone environment.
I want to be able to check free disk space in my stored procedure, so I can determine if a query is likely to extend the transaction log, or eat up more disk space than is available, so my app can just refuse to complete the operation (and have the user refine the criteria). Is there an easy way to do this ? I guess I could shell out to command prompt, and parse the results, which is fine, until a database is spread across 2 filegroups on different drives. Any ideas please?

---

From http://www.sql-server-performance.com/ac_extended_stored_procedures.asp] xp_fixeddrives
This very useful extended stored procedure returns the list of all hard drives and the amount of free space in Mb for each hard drive. To see the list of drives, run: EXEC master..xp_fixeddrives Satya SKJ

---

Thanks satya

---

]]>