title: Collation conflict using 2 versions of SQL Server
body: <p>I am working on 2 versions of SQL Server i.e 2005 and 2008 R2.  </p>
  
  <p>From 2008 R2 I have created a linked server which will connect to an older SQL Server 2005 instance.</p>
  
  <p>I have one table on my server (2008) which is as below</p>
  
  <p>members</p>
  
  <pre><code>id                  name     
  0002320         AOne Enterprises Motihari
  0002321         AOne Enterprises Siliguri
  </code></pre>
  
  <p>Another table which resides on remote server contain activity of each agent </p>
  
  <pre><code>id  member_code agent   rr_no   txn_date    amount
  </code></pre>
  
  <p>I fired a query below</p>
  
  <pre><code>select top 5 * 
  from [192.168.6.3].sync.dbo.agents_log
  where member_code IN 
        (select id from members where name like 'AOne Enterprises%')
  </code></pre>
  
  <p>I was trying to pull all activity log of AOne Enterprises through out the country which is in distributed database , so I need to create a link servers. </p>
  
  <p>I got this error:</p>
  
  <blockquote>
    <p>Msg 468, Level 16, State 9, Line 1<br>
    Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_BIN" in the equal to operation.</p>
  </blockquote>