Another FYI...

If you're in a situation where you want to consolidate all your collation settings after rebuilding your master, here's an article I wrote for SQLAuthority, including all the source scripts for automating the collation changes. These script capture everything all the way down to column level.

The only caveat is that these scripts cannot handle Statistics, because Stats can't be scripted out - or at least I haven't been able to find a way to do so.

http://blog.sqlauthority.com/2009/10/19/sql-server-change-collation-of-database-column-t-sql-script-consolidating-collations-extention-script/

Hope this is helpful to some.