sqldba2013
asked on
SQL server collation error
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.
SQLQuery.sql
Msg 468, Level 16, State 9, Line 35
Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI
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.
SQLQuery.sql
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER