Amit Raut (10/15/2013)
Agreed Jeff! That could be the reason why Microsoft also changed pie-charts to display disk status in 'My Computer' ;-).Well, do you have any SQL script for getting the status?
I do... but most people won't use it because it calls PowerShell using xp_CmdShell to get at WMI functionality. I'm one of those folks that don't believe in the myth that disabling xp_CmdShell provides any additional security except maybe for a 3ms burp in a hacker's attack engine.
--Jeff Moden
Change is inevitable... Change for the better is not.