I am trying to execute sql script in SQL Server 2012 with linked server setup but it is showing this error.
Msg 468, Level 16, State 9, Line 35
Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI
_AS" in the equal to operation.
Please find the attached script.
I tried to collate tables with different collations but it did not worked.
Pls suggest me how to resolve this issue.