{"id":1332,"date":"2017-01-22T13:10:26","date_gmt":"2017-01-22T13:10:26","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=1332"},"modified":"2017-01-22T13:10:56","modified_gmt":"2017-01-22T13:10:56","slug":"list-filestream-database-in-sql-server","status":"publish","type":"post","link":"https:\/\/www.theSQLReport.com\/?p=1332","title":{"rendered":"List FILESTREAM databases in SQL Server"},"content":{"rendered":"<p><strong>Problem<\/strong>: Received a support ticket requesting help with the <span class=\"st\">FILESTREAM<\/span> database for a SQL Server.\u00a0 Was given only the server name.\u00a0 This server had over 50 databases in the\u00a0SQL Server instance.\u00a0 Needed to quickly find which of these databases are <span class=\"st\">FILESTREAM<\/span> databases.<\/p>\n<pre>-- Need to be run on SQL 2012 or higher\r\nSELECT\r\nDB_NAME(database_id) as \"Database Name\",\r\ndirectory_name as \"FileStream Directory\"\r\nFROM\u00a0 sys.database_filestream_options\r\nWHERE non_transacted_access_desc &lt;&gt; 'OFF';<\/pre>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2017\/01\/ListFilestreamDatabases.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1333 size-full\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2017\/01\/ListFilestreamDatabases.jpg\" alt=\"ListFilestreamDatabases\" width=\"337\" height=\"313\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Problem: Received a support ticket requesting help with the FILESTREAM database for a SQL Server.\u00a0 Was given only the server name.\u00a0 This server had over 50 databases in the\u00a0SQL Server &hellip; <a class=\"readmore\" href=\"https:\/\/www.theSQLReport.com\/?p=1332\">Continue Reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1333,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[91],"class_list":["post-1332","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","tag-filestream"],"_links":{"self":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1332"}],"collection":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1332"}],"version-history":[{"count":3,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1332\/revisions"}],"predecessor-version":[{"id":1336,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1332\/revisions\/1336"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/1333"}],"wp:attachment":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}