Hey Guys, thanks for the help, Bill that looks like kind of what I would need but my main goal for this query would be to get the total allocated space for a mount point and the free space left in that mount point so it doesnt look like I can get that info from just sys.master_files or sys.database_files. Is there perhaps another system table I could query for mount point info in 2005 or 2008? Ill take a look at Glenn Berry's site to see if anything exists but its looking more and more like im going to have to create a temp table and/or powershell script for it. thanks!

-Matt