Solved

Query an Entire Database for a string

Posted on 2008-06-25
1
1,261 Views
Last Modified: 2010-08-05
I heard that in SQL Server 2k5 you could query an entire database for a phrase say 'XYZ' if that is true, does anyone know how to do it ?
0
Comment
Question by:basile
1 Comment
 
LVL 13

Accepted Solution

by:
rickchild earned 500 total points
ID: 21874623
Check out this procedure, it will search all string fields in all tables in a database for a 'XYZ'

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question