Let me suggest another simple method to implementing production database changes.
Use a DTS or SSIS Package.
Several years ago we agreed with our development staff that all database changes would be implemented using DTS Packages. The developer creates the package with all the scripts put into steps so that they will run in the correct order. The developer runs the package in the development and test environments. When the changes are ready for production, the dba runs the package in production. This has worked great for us.
It is simple, secure, and the chance of error is very small.