Thank this author by sharing:
By Babak Pirooz,
This script will allow you to search table and field in all database and return field value. Below is an example of the what the output will look like.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.