Change database collation (see ALTER TABLE) it’s very easy, because there are lots of tools (AlterCollation.exe ? ) that do the dirty work for you.
But, you have to look carefully at database links.
Yes, collation are stored in database links too, so when you change db collation you need to re-create those links.
Technorati Tags: SQL Server, Collation