• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 176
  • Last Modified:

SQL-Error--related to COLLATION.

I take a bachkup of my database from 1 serverand then restore it to another server, but now at new server some procedure of my database are not working properly , giving error that  " Cannot resolve collation conflict for equal to operation ”.
Thanks in advance .
Nishant
0
Nish_since1981
Asked:
Nish_since1981
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
this error means that you compare 2 values (ie 2 columns) that have a different collaction (ie collations that are not compatible.

check the server, database, table and columns related to the query to find out which collation applies.

to solve that: depends on what you can do and what differences there are.

0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now