Must get round to writing this as an articel some time. [BigGrin]
This document assumes that the SERVER is at the correct collation and that the DATABASE is a different collation to the server. These steps will bring the Database into alignment. It is for SQL 2005 ONLY and make sure you have a backup of the database before you start.
That is almost funny you are going to write an article about how to change collation in a database a task not related to INDEXES with a Cursor code going through Microsoft system database tables. That means your code may be doing what is needed to rebuild the Master and I am not so sure it is valid. I do this all the time including changing the Northwind sample database to SQL Server 2008 and Unicode encoded. Check below for the manual way which is how people who work in many languages do it. I also understand people want short cuts but the valid way to do that is to rebuild the Master.
http://msdn.microsoft.com/en-us/library/bb330962(SQL.90).aspx
Kind regards,
Gift Peddie