Querying Linked Servers

We recently linked two of our SQL servers and I was looking forward to the
luxury of querying across them. However, I am getting the following problem:

Cannot resolve collation conflict for equal to operation.

I understand this has something to do with Collating, but don't quite know
how that associates with my query which is below:

select sc.custid from SQL.bradco_prod.dbo.sc_customer sc left join
BIXS.Insite.dbo.zzbdw_arbal_keith a
on sc.custid = a.custid
inner join BIXS.Insite.dbo.zzbdw_shipto_vw v on
a.custid = v.custid and
a.shiptoid = v.shiptoid


Can anyone please point me in the right direction?

--
Message posted via http://www.sqlmonster.com
.

Loading