I'm with you 100% on the need for an automated method to change management. I agree with you completely on how the automated process should work.
The key to making all of this work is described as the "change control tool". The problem I have is that I haven't been able to find a comprehensive change control tool that does all the things that are described in the article.
One point that is missing on the change control tool is "system data". Schema is referenced frequently, but most databases also have tables that control certain aspects of the application. This system data would also need to be kept under source control and handled automatically by the vaporous change control tool.
If somebody can recommend a change control tool that does all these things and is affordable for a team of less than 10 people, I'm all ears!