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 |
inbs
Aged Yak Warrior
860 Posts |
Posted - 2012-11-19 : 02:43:08
|
how can i know by sqlwhat is the size of my disks in all my servers in the net.(sql server is not installing in all the servers) |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-11-19 : 02:48:15
|
hmm...do you mean you need to find out disk size of boxes where sql server is not installed by using t-sql?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2012-11-19 : 04:09:46
|
yes, do you know if it possible?if not, do you know free tool for that? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-11-20 : 02:44:23
|
quote: Originally posted by inbs yes, do you know if it possible?if not, do you know free tool for that?
why do you need to do it from sql? why cant you use a batch script for that?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2012-11-21 : 16:54:25
|
do you have example of batch? |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2012-11-21 : 23:20:46
|
use xp_fixeddrives to find the free disk space; let me know if this is what you are looking for |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|