Hy Guys!

I`m having a new problem today!
I Have two Databases, with the same collation configuration. (SQL_Latin1_General_CP1_CI_AS). But when I execute this qery, I got the collation message error:


select * from Cheque C
where
NOT EXISTS
(SELECT A.cmpCod + A.banCod
FROM dbCorporativo.dbo.Agencia A
WHERE
C.chqCmc7Compe + C.chqCmc7Bco
=
A.cmpCod + A.banCod
)

Result
Cannot resolve collation conflict for equal to operation.


This query executes with succes when I execute it like this:
select * from Cheque C
where
NOT EXISTS
(SELECT A.cmpCod + A.banCod
FROM dbCorporativo.dbo.Agencia A
WHERE
C.chqCmc7Compe + C.chqCmc7Bco
=
A.cmpCod + A.banCod COLLATE SQL_Latin1_General_CP1_CI_AS
)



Some suggestions? Since the configuration for the two databases are identical?

Ooopppss!! WRONG FORUM!

Sorry guys!

Diogo,

The model database must have different collation settings, temp databases / tables obtain/inherit the model database settings. When you specify a collation it sets the collation and thus there are no problems.