• We have a system we use at the company I work for that I think works well for us.  It uses a combination of tools (all on line - no paper) including Rational Clearquest (for database change requests), Redgate SQL Compare (for creating base/change/rollback scripts) and Source Safe (for saving/updating the 3 scripts for each change).  Each change in reviewed and migrated from Dev to Test and from Test to Production by a DBA.  No developer has DBO permissions except in Dev.

    This has greatly descreased our problems found when implementing changes to our production databases.  This article is lacking much helpful information regarding how to set up a system to monitor and save changes, but is a good start at evaluating the process.

    Have a great day,

    Linda Leslie

    Premier Lease & Loan Services