Retrieving SQL Server Database List

[culshaja]

Hi,

I want to get access to the list of SQL Server databases that the user currentl has defined on their machine. Its to produce a drop down list like the one you see in Query Analyser. I have tried accessing the registry but I am having a few problems.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[Rajeswari]

Hi,

Use SQLDMO object library to retrieve the database list.
Refer books online, Search for SQLDMO.

In MSDN search for SQLDMO->CREATE TABLE.

u will find the sample code.

In Visual Basic using references add SQL DMO object library and create the instance of SQLDMO and u will find lot of methods.