Posted by Joe Cool on 06/08/05 01:18

On Tue, 07 Jun 2005 17:52:02 GMT, "_AnonCoward" <abc@xyz.com> wrote:

>I have MSDE running on my system and I want to get a list of databases
>for that server programmatically. I'm using vb.net and I want to view,
>add, delete and modify databases on a server from within a class.
>
>
>I'm aware I can use the "Server Explorer" feature in Visual Studio, but
>that isn't what I'm looking for. Any references or suggestions on where
>to start are appreciated.

I have used the Information Schema to do this with:

select catalog_name as name from information_schema.schemata

This worked fine with SQL7, but I have had some problems with it with
SQL2K. User databases don't show up in the Information Schema until
they have been accessed.

[Back to original message]