I changed the collation of a database to SQL_Latin1_General_CP1_CI_AI, but there's one table that each time I try to reinstall the triggers or reindex, or any other operation, it returns this error:
"Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve collation conflict for equal to operation."
I have checked the collation of the table, and all of it's columns, and all of them have the right collation, but it still gives the error each time I try to execute some operation on the table.
This happened on two other tables, but a single drop solved the problem.
I have tried to drop this table and create it mannualy and tried to export the table to dbf and import it again but with no success on both.
I would appreciate any kind of help.
Thanks