469,081 Members | 1,861 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

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 bunch

Jul 23 '05 #1
2 1704

Hippi 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

Jul 23 '05 #2
No, it doesn't work. It shows all the databases I have in SQL Server

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by BruceGilpin | last post: by
5 posts views Thread by Thomas Jespersen | last post: by
reply views Thread by wwalkerbout | last post: by
1 post views Thread by Paul Sullivan | last post: by
4 posts views Thread by phcmi | last post: by
8 posts views Thread by =?Utf-8?B?Um9ubmllIFNtaXRo?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.