Determine which databases have FILESTREAM configured in a SQL Server instance

Posted by

exec sp_msforeachdb
‘use [?];
select [DBName]=”?”, ds.* from sys.data_spaces ds where type=”FD”’