Simple-talk.com has a pretty in depth article about deployment and mangement of databases.
Rolling out changes to the application is only 1 part of a deployment. Updating the database can be more difficult depending on your schema.
We could have more process around the DB development and deployment process. I will be giving this a read shortly.