Doing a join across two databases with different collations on SQL Server and getting an error

You can use the collate clause in a query (I can’t find my example right now, so my syntax is probably wrong – I hope it points you in the right direction)

select sone_field collate SQL_Latin1_General_CP850_CI_AI
  from table_1
    inner join table_2
      on (table_1.field collate SQL_Latin1_General_CP850_CI_AI = table_2.field)
  where whatever