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

Advertisements