SQL Server Script to Search For a String in a Table
I had an urgent request the other day to find all the pages on a site that contained a certain string of text. The entire website is dynamic, so all the content lives in the database. I came across an article from MSSQLTIPS.com that showed a nice little stored procedure to search for a string of text in a given table. It worked like a charm and immediately showed me all my pages that contained the text I was looking for. You can view the full article here from MSSQLTIPS.com.