RE: [OT] Loading file into a row

>If SQL Server then the path is relative to the server and the permissions will depend on who the statement is executing as. OH NO! ... I forgot that I was using the SQL Server instance on my file server, so it was looking for the file on the wrong machine. Now it works! Thanks Greg

RE: [OT] Loading file into a row

Hi Greg That should work if the file is accessible by the SQL Server process. The path 'E:\icons\SM\accicons04.ico' must be on the SQL Server's local file system - not the client machine unless it is the same machine. Also, the account that is running the SQL Server service will need sufficien

Re: [OT] Loading file into a row

If SQL Server then the path is relative to the server and the permissions will depend on who the statement is executing as. -- Regards, noonie On 27 June 2010 14:32, Greg Keogh wrote: > Who’s working on Sunday? ... I’m trying some sample code that is supposed > to bulk load a file into a varb