It's great to be able to have different collations on the same server, and even in a
different columns. But in many cases, you are not interested in having a multi-collation
server, but you only want a single collation. I have submitted several other suggestions
to minimise the impact and the risk for it to happen. However, even if all these are implemented, there will still be users sitting with a datbase that for one reason or another have the wrong collation. Today they are very much left on their own. You can change the
database collation with ALTER DATABASE, but it only changes the collation for metadata, and the restrictions precludes it from being usable for a database of any complexity. (What?
CHECK constraints not permitted?)
One way would be put this a tool of some sort, for instance the Copy Database Wizard.
However, it's hardly any secret that I have don't any high regards for CDW. I think this
should be in the engine.