SQL Server collation conflict: Msg 468, Level 16, State 9, Line 3 Cannot resolve the collation conflict between 'x' and "x" in the equal to

The error message on subject line is familiar in a distributed environment that results into collation conflict. I had no exception due to the nature of work I handle on day-to-day and within individual clients. The distributed environment means it can be in same location having the dependancy for the application to use a multi-lingual application or servers located in different geographical locations, then collation will give a kick in the process with conflict issues. Also for the previous versions...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2010/12/14/9274.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9274" width="1" height="1">