I was thinking of something like this. It would work and I could script it so it would at least start off automated. I could poke holes in it since the existing deprecated sprocs that we currently drop would not have extended properties. I think the question I am asking is to tough to answer. There are several solutions not automatic. I think we will need to keep with our static list of sprocs to drop to avoid other potential issues. That or a table with the version and checkbox if it is obsolete.

Thanks for the time and the idea