Read more about the article Default collation different from instance default
Microsoft SQL Server

Default collation different from instance default

If you have databases with another default collation than the instance default, you may get something like the following error:

[red_box]Msg 468, Level 16, State 9, Line 30 Cannot resolve the collation conflict between “Finnish_Swedish_CI_AS” and “Finnish_Swedish_100_CI_AS” in the equal to operation.[/red_box]

(more…)

Continue ReadingDefault collation different from instance default