Posted by Erland Sommarskog on 09/18/07 12:03

Yas (yasar1@gmail.com) writes:
> Anyone know why I'm getting the following error when I run the above?
> "Server: Msg 446, Level 16, State 9, Line 1 Cannot resolve collation
> conflict for equal to operation."
>
> Its all from the same Table so strange that there would be a Collation
> conflict?

Collation is set by column, so it could happen. Use sp_help to review the
collations.

A possible reason that you created the table, changed the database
collation, and then added more columns to the table.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Retrieve ONLY first/max
• Prev in forum: Re: ODBC & Remote SQL Server
• Thread view: Re: MS SQL compare columns to generate display name

[Reply to this message]