Query-specified tables exist in those databases __ database

--Query the specified tables exist in those databases

declare @tbname sysname
Set @tbname = ' Customer profile '

declare @dbname sysname, @sql nvarchar (4000), @re bit, @sql1 varchar (8000)
Set @sql1 = '
Declare TB cursor for select name from Master. sysdatabases
Open TB
FETCH NEXT from TB into @dbname
While @ @fetch_status =0
Begin
Set @sql = ' Set @re =case when exists (select 1 from ['
+ @dbname + ']. sysobjects where xtype= ' U ' and Name= '
+ @tbname + '] then 1 else 0 end '
EXEC sp_executesql @sql, N ' @re bit out ', @re out
If @re =1 Set @sql1 = @sql1 + ' UNION ALL SELECT ' + @dbname + ' "'
FETCH NEXT from TB into @dbname
End
Close TB
Deallocate TB
Set @sql1 =substring (@sql1, 12,8000)
EXEC (@sql1)