I have seen in so many blog posts a proposed solution to the ‘cannot resolve the collation conflict’ problem; many of the blog posts and forums suggest that the collate database_default will solve the problem.

As I got a similar problem a few days ago, I stopped for a second and I though ‘hm, can

Powered by Good Will. (Will is the person who offers his sympathy to others together with ideas, but who does not give any guarantee about the completeness of the concepts or the immaculate perfection of the scripts on this site. Use this site to grasp SQL Server concepts and to get knowledge. )