I am getting an error, Cannot resolve the collation conflict between xxx and yyy in the equal to operation.
When I am checking the collation setting, strange thing is that I get two records:
SELECT
col.name, col.collation_name, Object_ID('Spouse'), Object_Name(Object_ID('Spouse'))
FROM
sys.columns col
WHERE
col.name = 'spFirst'
SpFirst SQL_Latin1_General_CP1_CI_AS 187915791 Spouse
spFirst Latin1_General_CI_AS 187915791 Spouse
So the second row show the same field name in lower case with a different collation than the table has.
EXEC sp_help Spouse
Shows only fields with the correct collation. Where does this second collation come from, and how can I modify the mismatched collations?
Christian Isberner
Software Consultant