I have two tables in the same database. The server collation is set to Latin1_General_CI_AS , but the database and table columns are all set to SQL_Latin1_General_CP1_CI_AS. I have checked all indexes and they are also collated SQL_Latin1_General_CP1_CI_AS
I am getting a join error when i try and join a varchar field between the tables :
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
BUT both join fields are using SQL_Latin1_General_CP1_CI_AS.
I thought it might be dodgy data in the table (Incorrect for collation) so i created and empty copy of the table and same issue.
It is some how believing the column is collated Latin1_General_CI_AS even though the proerties say it is Latin1_General_CI_AS.
i dont know what else to look for ,
Very confused