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.


comments powered by Disqus