help ME SQL2000

hello to all,
I have installed two serveur with sql server 2000,
one server a store launch one procedures and all it goes
two server error : Serveur MSg446, level 16 been 9 linens 1 CANNOT resolve COLLATION conflict for equal to operation.
I do not succeed to understand the type of problem you can help
thanks me
maurizioI'm unsure what the procedure is trying to do :confused:|||Originally posted by ncapi
hello to all,

I have installed two serveur with sql server 2000,
one server a store launch one procedures and all it goes
two server error : Serveur MSg446, level 16 been 9 linens 1 CANNOT resolve COLLATION conflict for equal to operation.
I do not succeed to understand the type of problem you can help
thanks me
maurizio

Istruction :
CREATE TABLE #zeta (
a VARCHAR(6) NOT NULL,
b DECIMAL(9) NULL
)

ALTER TABLE #zeta
ADD
CONSTRAINT zK_t
PRIMARY KEY (a)

SELECT RET.ID_R
FROM EL, RET, AN, #zeta
WHERE
EL.a LIKE @.P_COD_4 AND
EL.a1 = @.P_COD_1 AND
EL.a2 = @.P_COD_2 AND
EL.a3 = @.P_COD_3 AND
RET.ID_E = EL.ID_E AND
RET.COD_STATO = 2 AND
AN.ID_1 = RET.ID_1 AND
#zeta.a = EL.a
)