Recently I was given the task of updating the text in all the stored procedures on a server; the client had changed one of their servers and we had to update the code to point to it.
This article contains a select statement that will show you how to search the text of all stored procedures on a server