• If you are using the exact same code in multiple procedures I'd look at seeing if I could change the procedures to call a common procedure where needed rather than maintaining the identical code in multiple locations.

    Also, not too familiar with using source control with database objects, but it may be possible to control changes in multiple procedures this way so that you only maintain the code in one place.