List All Databases In A MOSS 2007 Farm
Run the following script in the content database:
SELECT o.[Name] AS 'DatabaseName',
Instance.[Name] AS 'DatabaseInstance',
[Server].[Name] AS 'DatabaseServer'
FROM Objects AS o
INNER JOIN classes c on c.id = o.classid
LEFT JOIN Objects AS Instance ON o.ParentId = Instance.Id
LEFT JOIN [Objects] AS [Server] ON Instance.ParentId = [Server].Id
WHERE c.Fullname LIKE '%Administration.SPConfigurationDatabase%'
OR c.Fullname LIKE '%Administration.SPContentDatabase%'
OR c.Fullname LIKE '%Administration.SharedDatabase%'
OR c.Fullname LIKE '%Administration.SearchSharedDatabase%'