Doing a quickie here...
I had a need to extract all the databases into an excel to report on them. Here's a cool SQL which came handy for me:
Open SSMS (SQL Server Mgmt Studio) and fire this sql in the query window:
This will list all the databases name, alongwith some other useful info like size, owner when the db was created, db statust etc. Quite handy. Love SQL :-)