Hi Friend,
You need to make Audit of all New Procedures and Track the Procedure Changes with Procedure Text right.
Here clearly explained how to do Audit in care of any procedure changes in DB. You will go for
Database Trigger and get the details from Trigger and Store in a table in Different DB also.
Check the following link....
Try this, If any difficulty let me know....
SQL Server DDL Triggers to Track All Database Changes[
^]
Regards,
GVPrabu