A bit of code from MyITForum.com with a report that lists all collections for a specific machine. http://www.myitforum.com/forums/All_Collections_for_a_specific_computer/m_163312/tm.htm
Month / September 2007
A quick way to check and see all databases for your MS SQL server is to run the following command using the Query Analyzer on the Master database: