list of databases in Analysis Services

Hi all,

I have to write a program to read the names of databases in Analysis
Services. I don't know which table I can get this information from.

Thanks a bunchHippi wrote:
> Hi all,
> I have to write a program to read the names of databases in Analysis
> Services. I don't know which table I can get this information from.
> Thanks a bunch

would this work:

select dbid, name
from master..sysdatabases
where has_dbaccess(name) = 1

--
David Rowland
http://dbmonitor.tripod.com|||No, it doesn't work. It shows all the databases I have in SQL Server