I suppose the problem is that many (most?) people use stored procedures without source control? Stored procedures are often created and modified manually, dire

I suppose the problem is that many (most?) people use stored procedures without source control? Stored procedures are often created and modified manually, directly in place, maybe by some external team/consultant, with total opacity about what SPs exist on which databases and with what code, when they changed etc. There is of course no need for things to be this way.