Imagine the following scenario: I have two servers which are on two separate private networks.

A linked server has been created, and there is a table in server A which has an updated version of the same table on server B. The updates are not extensive, essentially just a reassignment of some Boolean values.

The connection between the two servers is reliable but relatively slow, and there is a collation mismatch between the two tables.

Is there a recommended or standard way of updating information between two servers with a collation mismatch?


You use the collate operator in the join. Such as:

select <column list>
from dbo.firsttable f
join linkedserver.database.dbo.secondtable d 
   on f.name collate database_default = d.name collate database_default 

Of course, you can also specify a specific collation, such as: SQL_Latin1_General_CP1_CI_AI

| improve this answer | |
  • I never have had to do both sides for collate database_default in the past, but this works as well. Accepting your edit. – RLF Apr 28 '15 at 20:17
  • Reminded me of a problem during my Jr. DBA days. :) – Ali Razeghi Apr 28 '15 at 20:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.