set nocount on
declare @name varchar(128), @substr Binary(32), @column varchar(128)
set @substr = 0x846200155D005A0F11E63DA1C289EEA4 --значение, которое будем искать

create table #rslt1
(table_name varchar(128), field_name varchar(128), value binary)

declare s cursor for select table_name as table_name from information_schema.tables where table_type = 'BASE TABLE' order by table_name
open s
fetch next from s into @name
while @@fetch_status = 0
begin
 declare c cursor for 
	select quotename(column_name) as column_name from information_schema.columns 
	  where data_type = 'binary' and table_name  = @name
 set @name = quotename(@name)
 open c
 fetch next from c into @column
 while @@fetch_status = 0
 begin
   print 'Processing table - ' + @name + ', column - ' + @column
   exec('insert into #rslt1 select ''' + @name + ''' as Table_name, ''' + @column + ''', ' + @column + 
	' from' + @name + ' where ' + @column + ' = ''' + @substr + '''')
   fetch next from c into @column
 end
 close c
 deallocate c
 fetch next from s into @name
end
select table_name as [Table Name], field_name as [Field Name], count(*) as [Found Mathes] from #rslt1
group by table_name, field_name
order by table_name, field_name
--Если нужно, можем отобразить все найденные значения
select * from #rslt1 order by table_name, field_name
drop table #rslt1
close s
deallocate s

DECLARE @binary Binary(32) = 0x846200155D005A0F11E63DA1C289EEA4;
SELECT *
  FROM _Reference297
    WHERE _IDRRef = @binary