Hello,

I want to display the running instances of SQL server in the drop-down list,
allow the user to enter username/password, if successfully connected i want
to display list of tables in another window.

is there any .Net framework assembly which I can use to retrieve running
instances and object of Database dynamically (reading schema).

Thanks,

Hi,
This link presents a procedure that can be used to populate a Windows Form
combobox with a list of SQL Servers by using SMO.Although not given you can
list the tables also using SMO.You can google for SMO and you will get plenty
of articles on it.SMO applies for SQL Server 2005.For SQL Server 2000
equivalent for SMO was DMO.
http://www.sqldbatips.com/showarticle.asp?ID=45
--
If my answer helped you,then please do press Yes below.
Thanks and Regards.
Manish Bafna.
MCP and MCTS.



[quoted text, click to view]