Please help me on below query .
NOTE : Please excuse my programming skills , the code is of mistakes .
I want the output like Database name in one column and the FileStream enabled or disabled in another column . Just 2 columns I am trying out for . Thanks
To find the Database name and if FileStream is enabled for the Database .
declare @cmd varchar(500)
set @cmd='USE ?
if exists(
select name, Filestream from sys.database_files where type_desc='FILESTREAM')
CASE type_desc WHEN 'FILESTREAM' THEN 'Filestream Configured For Datbase' ELSE 'Filestream NOT Configured For Datbase'
PRINT 'Filestream Configured For Datbase'
else
print 'Filestream Not configured for database'
inner join sys.databases where name not in (''master'', ''tempdb'', ''model'', ''msdb'')')
exec sp_MSforeachdb @cmd
Best Answer
Reference:
I would rephrase you question to find databases that are using
FILESTREAM
. Because you can only enableFILESTREAM
at an instance level in order to use it in any user database.To find all the files related to
FILESTREAM
or database name you can use this query.