I'm looking for a stored procedure (or query) to search an entire
database for a specific string value and replace it with another. I'm
sure I saw an SP for this a while back by someone, but cannot find it
again. The SP took the search string and replace string as parameters
and did the rest. Any ideas where I can find this ?

Bear in mind, the idea is that this can be re-used and run on any
database, so it would have to find all tables and search through those.
Ta

Ryan