|
|
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.
Navigation:
[Reply to this message]
|