Find directory of FileStream files for a column
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
September 11th, 2015 11:13am
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.
September 11th, 2015 11:21am
Check if GetFileNamespacePath helps.
https://msdn.microsoft.com/en-us/library/ff929166.aspx?f=255&MSPPError=-2147217396
September 14th, 2015 2:03am
.... And more importantly ... you should access the data only through queries or OpenSqlFilestream.
September 14th, 2015 3:31am
Check if GetFileNamespacePath helps.
https://msdn.microsoft.com/en-us/library/ff929166.aspx?f=255&MSPPError=-2147217396
Thanks. I will try it out and report back.
September 14th, 2015 3:39am