I can locate the FileStream Folder for a database with this query:

use [db];
select [physical_name] from [sys].[database_files]  where [type_desc] = 'FILESTREAM';

However, is there a way to find the subfolder for a specific FileStream column?  (Named with a GUID).

Thanks.

• Edited by Neil Weicher Friday, September 11, 2015 11:13 AM

I would not expect that there is. And more importantly, you should consider the FILESTREAM area to be off-limits. That is, you should access the data only through queries or OpenSqlFilestream.

Check if GetFileNamespacePath helps.

https://msdn.microsoft.com/en-us/library/ff929166.aspx?f=255&MSPPError=-2147217396