I am trying to write a select statement that joins two tables from different databases on my SQL server. The issue is that the two databases are different collation ...

Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. This SQL Server tip illustrates how you can force the use of any specific collation. Collation ...