I know the values stored in the column, but i want to retrieve the column name

use Your_database
go

select 'select * from ' + t.name + ' where ' + c.name + ' = ''chicken'' union ' 
from sys.tables t join sys.columns c on t.object_id = c.object_id  
join sys.types tp on tp.system_type_id = c.system_type_id
where t.name = 'budgets' -->your 1500 column table name goes here
  and tp.name in (
			'text',
			'ntext',
			'varchar',
			'char',
			'nvarchar',
			'nchar'
  )

run this then copy the result of the query, remove the trailing union.