Find a Word in All Databases in SQL Server(TSQL)

If you want to find a word in all your databases in an instance, you are in the right article. The below code block search a phone number “5454077068” in my all database.

But note that we use phone number in the script as “‘545%407%70%68′”. Because there may be space characters. You should change your search word in this place.

You must also change the column names to be searched.

You should change the column names in the below code part:

Find a Word in All Databases in SQL Server:

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *