• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

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
0
bibi92
Asked:
bibi92
  • 3
1 Solution
 
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now