title: "Cannot resolve collation conflict" even after fixing the collation
body: <p>The current database I'm using "PrimaryDatabase" has the collation "<code>SQL_Latin1_General_CP1_CI_AS</code>", while the "SecondaryDatabase" I'm trying to access has the collation "<code>Arabic_CI_AS</code>"</p>
  
  <p>I changed the collation for the SecondaryDatabase and set it to " <code>SQL_Latin1_General_CP1_CI_AS</code>" and made sure it has been changed as well as in its tables.</p>
  
  <p>However, when i run the query below I still get collation conflict.</p>
  
  <pre><code>select * from [MYSERVER].[SecondaryDatabase].[dbo].[SecondaryTableName] 
  where ltrim(rtrim([SecondaryTablename])) not in (select ltrim(rtrim(PrimaryFieldname))  from PrimaryTablename where PrimaryFieldName2=1)
  </code></pre>