Code
declare
@sql varchar(max),
@column_name varchar(200);
set @sql = '';
set @column_name = 'BlackOutFromDate' --table name
select @sql = @sql + 'union all select ''' + name + ''' as DB_Name ,object_name(object_id) as table_name from [' + name + '].sys.columns where name = '''+ @column_name + ''' '
from sys.sysdatabases where sid <> 0x01 and version <> 0;
set @sql = right(@sql,len(@sql)-9);
exec(@sql);
declare
@sql varchar(max),
@column_name varchar(200);
set @sql = '';
set @column_name = 'BlackOutFromDate' --table name
select @sql = @sql + 'union all select ''' + name + ''' as DB_Name ,object_name(object_id) as table_name from [' + name + '].sys.columns where name = '''+ @column_name + ''' '
from sys.sysdatabases where sid <> 0x01 and version <> 0;
set @sql = right(@sql,len(@sql)-9);
exec(@sql);