Just check if this may help you:

You can start from sysobjects and syscolumns

Get the datatype and the search value as parameters

:For each object in sysobjects where type ='U'

:for each column of the sysobject where xtype = @datatype

check if the value exists in the table for the column selected

if the value exists then insert the table name and the column

name in ur table variable.

proceed until for all columns and all tables.