SERVERPROPERTY() function can be used to retrieve the Windows Share name configured for FILESTREAM access. Here is an example:
SELECT SERVERPROPERTY ('FILESTREAMShareName') AS FileSreamShareName/*FileSreamShareName--------------------KATMAIFS*/
Tags: FILESTREAM,