Buenos dias amigos tengo un problema con una store procedure y les agradeceria me ayudaran, mchas gracias...

me vota este error : Error 446: Cannot resolve collation conflict for equal to operation

Adjunto el store procedure:

CREATE PROCEDURE OF_CREAFC_CLIENTES
AS
INSERT INTO Customerstatus
    (CardNo, LastName, FirstName, Mi, Sex, MaritalStatus, Address1, Address2, City, State, Zip, GeographicId,
     Category, HomePhone, BusinessPhone, DL, CashBack, Balance, Discount, CreditLimit, ChargeOk, FrequentShopper, WriteChecks,
     StoreCoupons, GovermentCheck, PayrollCheck, TermsId, Type, ResaleNo, Link, ShoppedFor, Purchases, NumberOfChecks,
     PointsEarned, Memo, Deleted, CardIssued, Created, Modified, ModifiedBy, PricingLevel, ReceiptType,
     TipoCliente, TieneBeneficiarios, Empresa,  Salario,
     TipoIdentificacion, DescuentoPeriodo, MontoDsctoPeriodo, DsctoMultiplePeriodo,
     HoraIniDscto, HoraFinDscto, BirthDate)
SELECT
     IdCliente, '. ' , Nombre, 'R', 1 , 0 , Direccion, '' , Ciudad, '54', '54001' , 0 ,
     0, Telefono1, Telefono3,Tarjeta, 0, 0, 0, 0, 0, 1, 1,
     1, 0, 0, 0, 'PC', ' ', ' ', 0, 0, 0,
     0, ' ', 0, GETDATE(), GETDATE(), GETDATE(), 1, CASE WHEN TIPO='DETAL' THEN 2 ELSE 1 END AS TIPO, 0,
     '0', 0, Empresa,  0,
     ' ', 0, 0, 0,
     '00:00:00', '00:00:00',  Fhnace
FROM SERVIOFI.RAYOTEXSA.DBO.FC_CLIENTES
WHERE IDCLIENTE NOT IN (SELECT CARDNO FROM Customerstatus )

UPDATE  A
SET  FirstName=B.NOMBRE, DL=B.TARJETA,PricingLevel=CASE WHEN B.TIPO='DETAL' THEN 2 ELSE 1 END
FROM SERVIOFI.RAYOTEXSA.DBO.FC_CLIENTES B ,Customerstatus A
WHERE B.IDCLIENTE  = A.CARDNO AND YEAR(B.FHING)=YEAR(GETDATE()) AND MONTH(B.FHING)=MONTH(GETDATE()) AND DAY(FHING)=DAY(GETDATE())
GO