Don't have Telegram yet? Try it now!
http://www.macaalay.com/2011/12/19/the-easy-way-of-changing-collation-of-all-database-objects-in-sql-server/
The Easy way of changing Collation of all Database objects in SQL Server