In SQL Server, collations can be configured at several levels:
- the default collation for the entire server (instance)
- the default collation of the database
- the collation of the column in some table

Check that the ccsi database and the upc_entry database have the same
collations. Do the same for the fields in the where phase. You can use
the COLLATE clause to cast a character expression to a certain
collation.

-----Original Message-----
From: sean
[mailto:mssqldba-ezmlmshield-x78818042.[Email address protected]
Sent: Friday, March 30, 2007 2:19 PM
To: LazyDBA Discussion
Subject: SQL Server Error Help Needed


Does anyone know why I would be receiving the following error when
running the below script?

Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.

The script looks like this...

SELECT
rtrim(a.UpcStyle),
rtrim(b.color_code)
FROM
ccsi.dbo.upccode a,
upc_entry.dbo.upc_rec b
WHERE
b.style_code=a.UpcStyle
AND a.UpcColor=b.color_code

Thanks!

Sean



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page