Tutorial :Find out FILESTREAM share name in T-SQL


Real quick question - I must be blind or something.

In SQL Server Mgmt Studio, I can check for the level of filestream support currently enabled by

EXEC sp_configure filestream_access_level  

Great, works. But how can I find the Windows share name specified during installation where the filestream data will actually be stored? I can't seem to find any settings, configuration option or anything to do that. Can this be?? I can't find this out??



Run the following query: SELECT SERVERPROPERTY ('FILESTREAMShareName')


Also, you can retrieve the Filestream support level without using sp_configure with the below option.

select SERVERPROPERTY(N'FilestreamConfiguredLevel')  

Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Next Post »