You can change the (default-)collation of a database with the ALTER DATABASE command. But this doesn't change the collation of the existing objects!! You need to change each existing object to the desired collation with an ALTER command. There's a script on codeplex to help you with this:

http://www.codeproject.com/Articles/302405/The-Easy-way-of-changing-Collation-of-all-Database