Alter Collation in SQL Server

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.

see also The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode

Technorati Tags: SQL Server, Collation