4

I want to know if I can find out list of analysis databases on an Analysis Server by simply writing a query. I am working on SQL Server 2008.

Niraj
  • 1,782
  • 1
  • 22
  • 32

1 Answers1

13

I am sharing this information by answering my own question here cause this I found out at a blog post and this I think is very useful for a BI developer. Following is the MDX query to get the list of SSAS databases on that server.

SELECT [catalog_name] as [Database Name] FROM $SYSTEM.DBSCHEMA_CATALOGS.
Niraj
  • 1,782
  • 1
  • 22
  • 32
  • I can't the blog post, I see only a blank page, not sure it's my browser issue or the link is not valid anymore. – FLICKER Aug 08 '16 at 17:34