SQL Server Performance

sql determining free disk space?

Discussion in 'General DBA Questions' started by Chappy, Feb 5, 2003.

  1. Chappy New Member

    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?

  2. satya Moderator

  3. Chappy New Member

    Thanks satya

Share This Page