943,931 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 4753
  • MS SQL RSS
Jun 8th, 2007
0

Check Free Space in .MDF

Expand Post »
How do you check free space or space used within an MDF? The "Percent Log Used" performance condition alert doesn't check MDF files. The sp_spaceused is close, but combines all files, and sp_helpfile shows current file sizes and growth specs, but not free/used.

How do you programatically get the same values shown by ShrinkFile when in Management Studio?

Thanks - D
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
DVHSr is offline Offline
3 posts
since May 2007
Jul 9th, 2007
0

Re: Check Free Space in .MDF

FYI to those scratching your head on this... I found a solution using the fileproperty function. Thanks for looking.
- D
Reputation Points: 10
Solved Threads: 0
Newbie Poster
DVHSr is offline Offline
3 posts
since May 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: database mail
Next Thread in MS SQL Forum Timeline: how to update garbled characters





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC