Altering Stored Procedure Families Programatically
Reprinted with permission from owner. Original at http://nlsimmons.com/SQLScraps/
Alter every stored procedure in a database that fits a given criteria
Recently I had to search for, and update, hard-coding server references for every stored procedure in a database. This amounted to altering over 60 stored procedures. Instead of going through each stored procedure, one-by-one, I used the following code to accomplish the task: