I know most of the real world isn't like this, but...

Developers need to track dependencies in comments in their procs/funcs..

PERIOD!

When all dependencies are gone, throw the proc in an unused...