Does anyone know an easy way to search for a string in a SQL Server database.

  • Questions
  • Does anyone know an easy way to search for a string in a SQL Server database.
Question ID: 104194
3
0

I’m trying to learn all about how things QC store information in the project database.
Does anyone have a stored procedure or SQL that can search for text strings?

Marked as spam
Posted by (Questions: 5, Answers: 1)
Asked on August 13, 2010 2:48 pm
18 views
Answers (1)
4
Private answer

I have used this one. Works really well.

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

Marked as spam
Posted by (Questions: 0, Answers: 613)
Answered on August 13, 2010 2:56 pm
Thank you, that is exactly what I am looking for.
( at August 13, 2010 2:59 pm)
That works great. Note to others, use a single quote instead of double quotes around the string. For example SearchAllTables 'FindThisText'
( at August 13, 2010 3:03 pm)
Alway glad to help where I can.
( at August 13, 2010 3:04 pm)