Greetings. I've seen a few people ask this question on google w no real solution.
We're using filestream, and I want to run a query in the DB that will allow me to tie the result of that query to the actual name of the filestream file.
This link shows the column filestream_value_name which is precisely what I'm after, but only shows stuff waiting to be backed up, while running in DAC. I need something that can tie every row of data in my table to the actual file name as seen in Explorer (for example).
I'm also aware of column.pathname , but that doesn't truly show what I need.
I'm also aware that manually manipulating these files is not supported, and could lead to corruption. I have no intention of doing that.