Tutorial :Find out FILESTREAM share name in T-SQL



Question:

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??

Marc


Solution:1

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


Solution:2

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
Previous
Next Post »