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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-05-07 : 10:49:50
|
| xp_fixeddrives gives the free space on the server drives. Is there a xp which gives the actual size of the drive?I need to calculate the %space used!------------------------I think, therefore I am - Rene Descartes |
|
|
pootle_flump
1064 Posts |
Posted - 2008-05-07 : 10:58:47
|
| Nothing inbuilt. There is stuff on the web if you google for it. Unless you have hundreds of servers I would just input the drive sizes manually. You can end up spending a lot longer figuring out how to automate this sort of thing for little real benefit. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-07 : 11:01:24
|
| I found some scripts which meet my requirement. But they also enable OLE AUTOMATION, bit skeptic about that!------------------------I think, therefore I am - Rene Descartes |
|
|
|
pootle_flump
1064 Posts |
Posted - 2008-05-07 : 11:11:24
|
Yeah - when we rolled our database trending stuff we initially wondered how to read disc sizes and then decided not to bother. There are better things you can do IMHO than go to great lengths to avoid typing:INSERT drivesSELECT 'myservername', 'C', 500  |
|
|
|
|
|
|
Free space