gbritton1 (5/13/2014)
This is kind of a trick question. The actual path is not stored in the schema at all. Rather the filetable path_locator is of data hierarchyid that identifies the position of this node in the hierarchical FileNamespace.I'm still not sure how to extract that actual path (i.e. conventional Windows path name)
The file will be visible in the location of the filegroup defined for FileTable, provided non transactional API have been allowed...
for further detail, see QotD Regarding FileTable[/url]
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”