get list of disks for MS SQL Server instance

Hello,

Is it possible to get of disks for MS SQL Server instance?
If yes, how?

Thanks
bibi92Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
PortletPaulfreelancerCommented:
EXEC master..xp_fixeddrives

see:
http://www.stevefibich.net/wordpress/2011/05/05/top-10-obsucre-t-sql-commands/
which also suggests:
EXEC Xp_dirtree ’c:’, 1, 1

which is further explained here
http://www.sql-server-performance.com/2001/extended-stored-procedures/

does this help?
0
 
bibi92Author Commented:
Hello
Thanks, i Know these commands. I search to get the Disks with powershell command.
0
 
PortletPaulfreelancerCommented:
ah, I see - in the topics - probbaly should include that in the question text - anyway:
I can spell powershell, that's about the limit :)
trust someone else will fill in that bit for you. Cheers. Paul
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.