T-SQL Script: Find Keyword in whole Database

Posted by on May 22, 2012 in SQL Server, T-SQL | No Comments

There are some times that you need to find all occurrence (or some of them) of a keyword in all columns/tables in a database, This is a usual scenario in data profiling. I wrote script below to fulfill this requirement, this script will search for specific keyword in all columns and tables of a database ...

Read More