extended stored procedure

• Momak

  Say Hey Kid

  Points: 687

  More actions

  August 2, 2005 at 5:30 am

  #114831

  Hello,

  I have share folder: "Share_Folder". 

  How could I find on which drive this folder is placed (C:, or D:, or ...).

  Is there any extended stored procedure with this purpose, or is there some other way to get that information.

• JP de Jong-202059

  SSCommitted

  Points: 1674

  More actions

  August 3, 2005 at 1:20 am

  #579029

  Hi

  Assuming you can start xp_cmdshell, try this:

  xp_cmdshell 'net share'

  JP

• Momak

  Say Hey Kid

  Points: 687

  More actions

  August 3, 2005 at 1:33 am

  #579031

  great, that's it.

  How to get drive name if folder is not shared ?

  

• Hans Lindgren

  SSChampion

  Points: 10496

  More actions

  August 3, 2005 at 6:58 am

  #579127

  Get the LEFT( @Path , 1) maybe?

• Momak

  Say Hey Kid

  Points: 687

  More actions

  August 3, 2005 at 7:03 am

  #579129

  I asked 'if the folder is not shared', and I have only the name of folder (not full path)

• Hans Lindgren

  SSChampion

  Points: 10496

  More actions

  August 3, 2005 at 7:12 am

  #579135

  Yes, and I answered to that. Ex: LEFT( @Path , 1) on 'C:\Windows\System' gives 'C'.

  And if you only have the name of the folder you have to search for it on your drives. How are you supposed to find it otherwise?