Here is an article I wrote about changing collation.
http://qa.sqlservercentral.com/columnists/glarsen/collate_part2_1.asp
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP