Script that alters all stored procedure on the database
Start out with getting all the procedures from sys.procedures

SELECT  * FROM sys.Procedures 


Then use EXEC sp_helptext on each to load the text of the procedures. 

Search for text to add, add if needed, 

Then load the updated text to a variable and execute dynamically.