Rob Farley recently blogged about an excellent idea for solving the annoying collation issues so many struggle with during updates, consolitations or server rebuilds.
Currently SQL Server throws errors if tables are joined with columns that have incompatible