finding sql databases in a server

how can i find the databases that belong to a sql server on the network.

Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)

Open Management Studio, connect to that instance and expand the Databases node. If that doesn't answer the question you actually want answered, which I suspect it won't, then please restate the question more clearly.

ok that was almost funny...i mean i want vb 6 code to list databases that belong to a server...i have written code that lists the sql servers on the network and after picking one server i want to list the databases in it.

EXEC sp_helpdb

Check out this also:

http://databases.aspfaq.com/schema-t...my-server.html

Check this out also.

thanks a lot ...you rock...it turn out to be simpler than i thought.