By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,985 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,985 IT Pros & Developers. It's quick & easy.

How to list all databases on MS SQL server in VB?

P: 2
I am wondering how to get a list of all the names of the databases on the server, from beginning to end. I have no clue where to start with this, meaning I am not sure how to connect to just the server and then query it for the database names. I don't know what variables to declare or what connections to use. If anyone can help it would be much appreciated.

Thanks
Apr 19 '07 #1
Share this Question
Share on Google+
2 Replies


100+
P: 149
I am wondering how to get a list of all the names of the databases on the server, from beginning to end. I have no clue where to start with this, meaning I am not sure how to connect to just the server and then query it for the database names. I don't know what variables to declare or what connections to use. If anyone can help it would be much appreciated.

Thanks
SQL Distributed Management Objects (SQL-DMO) is a collection of objects encapsulating Microsoft SQL Server database management and replication management. These objects are available through a Development library called SQLDMO.DLL from Microsoft. I think you can use this in your VB prgram to get the list of database from the SQL server.

-ansuman sahu
Apr 20 '07 #2

P: 2
SQL Distributed Management Objects (SQL-DMO) is a collection of objects encapsulating Microsoft SQL Server database management and replication management. These objects are available through a Development library called SQLDMO.DLL from Microsoft. I think you can use this in your VB prgram to get the list of database from the SQL server.

-ansuman sahu
Thanks, I appreciate it.
Apr 20 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.