PHWinfo - Afficher un message - MS SQL compare columns to generate display name

18/09/2007, 13h03

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_ 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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

18/09/2007, 13h03	#6
Erland Sommarskog Messages: n/a Hébergeur:	Re: MS SQL compare columns to generate display name 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_ 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/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx