I've been there! You are at a client site and you know you need certain data elements but aren't certain how many databases on a given server ...or ... which tables the data elements you are interested in might appear.
Here's a single statement when executed from any SMS query connection that will get you there:
EXEC sp_msforeachdb '
DECLARE @pattern nvarchar(100)
SET @pattern = ''%elementName%''
IF EXISTS(SELECT 1 FROM [?].information_schema.columns WHERE column_name LIKE @pattern)
BEGIN
SELECT ''?''
SELECT table_catalog,table_name, column_name
FROM [?].information_schema.columns
WHERE column_name LIKE @pattern
END '