Hello, I'm in a same dilema today with SQL 2008. I tried your advice using dynamic SQL in replacing the 'data_file' part of the OPENROWSET. Here is part of the sp code...

select * from OPENROWSET (bulk @PathFilename, single_blob) as document

where @Pathfilename stores the path and filename of the file.

i tried

select * from OPENROWSET (bulk '''' + @PathFilename + '''', single_blob) as document

but i get this > Incorrect syntax near '+'

I hope you have another workaround for this. Thanks