SQL Server: Search Every Table And Field
An important query to have in your toolbox will search through tables and fields.
Set a search string.
Create a stored procedure.
Follow the external link.
Follow the instructions.
There are times when getting granular on the backend is a good thing.
Search every table and field in a SQL Server Database Updated | Tim Gaunt.