Changing the collation of a database and all objects in it cannot be easily done using SQL Server Management Studio (as far as I know).
I found this tool that does all that, and it works on SQL Server 2000, 2005 and 2008. http://www.codeproject.com/KB/database/ChangeCollation.aspx
I found this tool that does all that, and it works on SQL Server 2000, 2005 and 2008. http://www.codeproject.com/KB/database/ChangeCollation.aspx
A .zip containing the .exe can also be downloaded from here; http://cid-2b938d415eef4e59.skydrive.live.com/self.aspx/Public/SQL/AlterCollation.zip
Tore Senneseth 