Query an Entire Database for a string

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 ?
Auerelio VasquezETL DeveloperAsked:
Who is Participating?
rickchildConnect With a Mentor Commented:
Check out this procedure, it will search all string fields in all tables in a database for a 'XYZ'

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.