SQL Server Performance Forum – Threads Archive

Mounted storage

If there some way we can use to automatically list or report the free space of mounted drives? ——————
Bug explorer/finder/seeker/locator
——————

You can use xp-fixeddrives extended procedure using tsql. Mohammed U.

it doesn’t work for mounted drives. ——————
Bug explorer/finder/seeker/locator
——————

I believe you need to findout from the Operating system and there is no direct query to get this from SQL. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

Yes, I know there is a windows command can be used to list all the mounted points, But I don’t know ——————
Bug explorer/finder/seeker/locator
——————

Check this thread…
http://groups.google.com/group/aus…. mounted points&rnum=2&hl=en#0f35dd2828b09b1f
Mohammed U.

Mohammed
That is relevant to Linux OS, I believe Xiebo looking for Windows command. http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct05/hey1011.mspx – good findings from Scripting Guy.
http://www.dba-oracle.com/t_sql_server_2005_windows_script_display_disk_space_usage.htm
http://www.adiscon.com/Common/en/Articles/monitor-windows-disk-space-with-scripting-host.php
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

Thank you, Satya and Mohammed, You guys are really helpful………………………….. ——————
Bug explorer/finder/seeker/locator
——————

]]>