• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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