Finding string value within a database

I had a need to track down which columns in the system had a particular string value. I used the below stored procedure to identify the tables and columns that contained a particular string value.

This script is designed to only find string values within the system, only looking at string fields that are large enough store the entire string.

Continue reading