title: SQL read file, access denied error
body: <p>I have the following SQL procedure:</p>
  
  <pre><code>   DECLARE @stament as nvarchar(max)
  
   set @stament='SELECT BulkColumn FROM OPENROWSET (BULK '''+ @Path+''', SINGLE_BLOB) MyFile '
  
  EXECUTE sp_executesql    @stament 
  </code></pre>
  
  <p>when I execute it, an error occurs:</p>
  
  <blockquote>
    <p>Cannot bulk load because the file "\MyServer\New Folder" could not be
    opened. Operating system error code 5(Access is denied.).</p>
  </blockquote>
  
  <p>I checked the permission on the folder, Everyone has full access, and the file exists.</p>
  
  <p>Thanks</p>