gbritton1 (5/13/2014)
I'm still not sure how to extract that actual path (i.e. conventional Windows path name)
During my investigation on this question, I came across documentation on the FileTableRootPath function. "It returns the root-level UNC path for a specific FileTable or for the current database".
http://technet.microsoft.com/en-us/library/gg509104.aspx
I don't know if this is what you were specifically referring to. I am new to FileTables and have not used this functionality yet.
Regards,
Brian
EDIT: forgot to add the URL reference.