Query below finds all databases in SQL Server instance containing particular table (table name must include schema name). In this case this table is dbo.version.

Query

select [name] as [database_name] from sys.databases 
where 
    case when state_desc = 'ONLINE' 
        then object_id(quotename([name]) + '.[dbo].[version]', 'U') 
    end is not null
order by 1

Columns

• database_name - database names

Rows

• One row represents one database
• Scope of rows: all databases containing provided table schama and name
• Ordered by database name

Sample results

All databases containing dbo.version table - that's how if search for Dataedo repositories.