"Sara C via SQLMonster.com" <u12659@uwe> wrote in message
news:59234cbecf98d@uwe...
> 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