Check SQL Server 2008 FIlestream status

Question

Hello guys,

Im using sql server 2008 filestream feature in one of my projects, is there a way to check the filestream status (if its enabled or not) using a query?

Thanks in advance.

Answer 1

You can certainly check that using the sp_configure system stored procedure:

exec sp_configure 'filestream access level'

or

SELECT * FROM sys.configurations
WHERE name = 'filestream access level'

Should give you something like:

name                 minimum    maximum config_value    run_value
filestream access level 0      2         0              0

• 0 = Disables FILESTREAM support for this instance.
• 1 = Enables FILESTREAM for Transact-SQL access.
• 2 = Enables FILESTREAM for Transact-SQL and Win32 streaming access.