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
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:
select name, filename from sysdatabases
