Hi Guys.

I have found a solution to this age old problem. Now I will just explain the cocept, in my next post I will give the code. I use it at a large bank. It requires that 1 DLL file (Basically you can compile the code yourself, if you like me you trust no one) and then put the DLL in a common folder on each server. I copy it to C:\Windows . Then this must be hooked into SQL. Then my tsql code runs against each instance in a loop. If you cycle through approx 2000 instances, some are bound not to have the .Net FW it requires. For that I handle it with a TRY...CATCH and just display the Free Space. Hence the Total Drive Space is just set to 0 for such servers. I could get creative and create a lookup table to replace the 0 with the size, but I did not want to do that, because some LUN Admin might change the size without me knowing. I would rather want to see 0 GB Total for servers with the .Net FW problem, so that I can address the .Net FW issue on such servers. I still use the xp_fixeddrives so I could not get away from this limitation yet.

Anyway, I have to run, but I will come back and what code I use to do the trick. I must say, I didn't write the CSharp code, but it works pretty good.