Granted most of my changes are minor like updating a stored procedure or view or adding a column. I also run them on a test database first.
Updates that may have a major impact on a table with millions of records, would never be done while the sites are up, but regular minor changes and fixes by nature do not have as wide an impact as major updates and fixes. If you are making major changes you would definitely need to to some testing and have a well planned implementation strategy. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm