From: matthew.wells@firstbyte.net   
      
   Actually in this case the server has the same mapped drives as all the users   
   so my question is still applicable.   
      
      
   "Erland Sommarskog"  wrote in message   
   news:Xns9EA7CCAECDEB6Yazorman@127.0.0.1...   
      
   Matthew Wells (matthew.wells@firstbyte.net) writes:   
   > I have done quite a bit of research on this, but could not find a good   
   > answer.  I need to get the UNC path from a mapped drive letter where the   
   > drive is mapped to another machine (not the SQL Server).  The drive is   
   > mapped the same on the server and all client stations.  My main course   
   > was to use sp_OACreate to create a filesystemobject and use the   
   > ShareName property of the Drive object.  The problem with that is that   
   > this only works for the server's local C drive.  When I try to use any   
   > mapped drive, it fails.  Here's what I've tried:   
      
   Supposedly only the C drive is mapped as far as SQL Server is concerned.   
   Disk mapping is a user-level thing, and they rarely apply for services.   
   So I'm afraid that you are in a dead end.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)