rayh 98086 (5/6/2013)

---

Hi,

I am using a stored procedure and would like it to find a file on a different server location. When on the server, I have access to the drive using UNC or if I map a drive. However, when I try to do this within my Stored Procedure it does not work. Any suggestions to what the problem may be?

The problem seems to be related to trying to reach the other server. (Could this be a network permission?)

Here is my code:

@GetFileName nvarchar(500),

@filedir nvarchar(50),

@cleanfilename nvarchar(500),

@filepath nvarchar(500),

@dircmd nvarchar(500),

-- 1. Get File from Upload directory and pull out file name

-- SET @filedir = 'Y:\' Mapped drive attempt

SET @filedir = '\\servername\directory\'

SET @cleanfilename = (SELECT SUBSTRING(@getfilename,4,100))

SET @filepath = @filedir + @cleanfilename

SET @dircmd = 'dir ' + @filepath