Who's working on Sunday? ... I'm trying some sample code that is supposed to
bulk load a file into a varbinary column of a table. My statement is this:
UPDATE TestTable set [Icon] = (SELECT * FROM OPENROWSET(BULK
'E:\icons\SM\accicons04.ico', SINGLE_BLOB) AS x ) WHERE [Name]='Foo'
But I
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