Conflict conflict using two versions of SQL Server

Question

I am working on two versions of SQL Server ie 2005 and 2008 R2.

Since 2008 R2, I created a linked server that will connect to an older instance of SQL Server 2005.

I have one table on my server (2008) which is below

of members

id name 0002320 AOne Enterprises Motihari 0002321 AOne Enterprises Siliguri 

Another table, which is located on the remote server, contains the activity of each agent

 id member_code agent rr_no txn_date amount 

I made a request below

 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%') 

I tried to pull the entire activity log of AOne Enterprises through a country that is in a distributed database, so I need to create a link server.

I got this error:

Msg 468, Level 16, State 9, Line 1
Cannot resolve collision conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_BIN" in equal action.

Answer 1

not quite sure what you need, but if its the only sorting problem you can do below

 SELECT TOP 5 * FROM [192.168.6.3].sync.dbo.agents_log WHERE member_code COLLATE SQL_Latin1_General_CP1_CI_AS IN (SELECT id FROM members WHERE NAME LIKE 'AOne Enterprises%') 

I just added COLLATE SQL_Latin1_General_CP1_CI_AS , maybe it works