how to list all the databases in the availables SQL server

[osama82]

Folkes, how are you all ,i would like to ask how can i list all the available Databases in a selected sqlserver! thank you :(( kind regards Osama Khattab

[OMalleyW]

SELECT name FROM master.dbo.sysdatabases Will I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

[javiersolis1983]

You must reference the COM Library Microsoft SQLDMO, you must install client tools and SQL service pack 3a in your PC. With this library you can list al server, for each server the databases and for each database all the tables. And other stuffs.