Collation conflict using 2 versions of SQL Server
not exactly sure what you need, but if its only collation issue you can do below
SELECT TOP 5 * FROM [192.168.6.3].sync.dbo.agents_logWHERE 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 , perhaps it work