Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
readysetstop
Posting Yak Master
123 Posts |
 Posted - 2007-06-27 : 13:07:28
|
| My lead has asked me to come up with a way to know when we are low on disk space. In the past, I've done similar things by extracting info from the system logs and bulk inserting it, but this is something new to me.Can SQL report on operating system or hardware specs?____________________________________________________________________________________"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-27 : 13:15:27
|
| Check out xp_fixeddrives to see free disk space for the drives on the database server.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-06-27 : 13:21:28
|
And with that answer + a little googling, I have exactly what I need.Thank you, Tara!  ____________________________________________________________________________________"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide |
|
|
|
|
|
|
Disk Space from TSQL - Is this even possible?